

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 …


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
1 Guest(s)
