Log In
Register
Home
June 27, 2022
Offline
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 …
See Answer
November 8, 2013
Offline
Hi Glenisa,
Hard to imagine how it should look, can you upload a sample file showing the before and after versions?
thank you
Trusted Members
Moderators
November 1, 2018
Offline
Date.Month(somedate) will return the month number to be used in your calculation.
June 27, 2022
Offline
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
Offline
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
1 Guest(s)
