June 27, 2022
maybe I’m just thinking too much about this, but I’ve been looking for answers.
So I have a given value and I wanted to find a way to multiply it based on the given month.
Given value is 40. So basically I would want it to look like this:
40 x 1 = 40 (January)
40 x 2 = 80 (February)
40 x 3 = 120 (March)
I have multiple categories which means multiple given value. How do I show this on power query so it automatically multiplies does value at a given month?I’m creating a small dashboard on excel and I’m creating custom columns using power query …
November 8, 2013
November 1, 2018
June 27, 2022
So basically I would use the months as a multiplier. Generally I would have it this way:
Given value Projected Value (if we were looking the month of March then we would use 3 as a multiplier, filtering it on March to use that as a multiplier)
When we move on to the next month then we will use 4 as a multiplier since April is the fourth month of the year. Then we keep going. I just want to be able to show that on my dashboard by using a filter of some sort
February 13, 2021
Extract the month number by converting your month names to dates (set a prefix of "1," and set data type to "Date")>Add Column>From Date & Time>Date>Month, multiply your Given value by the month number to a new column then if no longer needed you can delete the month number and date columns. You may want to extract the month name again from the date column before you delete it depending on your needs.