Forum

Multiplying given v...
 
Notifications
Clear all

Multiplying given value based on number of months

5 Posts
4 Users
0 Reactions
1,016 Views
(@glenisat)
Posts: 6
Active Member
Topic starter
 

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 … 

 
Posted : 28/06/2022 3:44 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Glenisa,

Hard to imagine how it should look, can you upload a sample file showing the before and after versions?
thank you

 
Posted : 28/06/2022 11:20 pm
(@debaser)
Posts: 837
Member Moderator
 

Date.Month(somedate) will return the month number to be used in your calculation.

 
Posted : 29/06/2022 4:22 am
(@glenisat)
Posts: 6
Active Member
Topic starter
 

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

 
Posted : 29/06/2022 12:36 pm
(@jstewart)
Posts: 216
Estimable Member
 

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.

 
Posted : 30/06/2022 10:26 am
Share: