June 27, 2022
Hello!!
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.
example:
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)
etc…
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 …
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Trusted Members
Moderators
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)
40 120
30 90
20 60
50 150
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
Trusted Members
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.
Answers Post