topic Re: Problem multiplying measure by column in DAX Commands and Tips

Problem multiplying measure by column

Userpath77 — Tue, 12 Dec 2023 20:58:36 GMT

Hello All

I have a measure which creates a monthly cumulative value that spreads across 12 months. I now need to create a new measure which calculates a percentage from each of the monthly cumulative values. To do this, I created a calculated column that lists all the monthly percentages for each month with a command to multiply them against the existing Cumulative measure. My results come back astronomical, can anyone point me to any guidance on how to deal with multiplying calcuated columns by measures?

Re: Problem multiplying measure by column

Sahir_Maharaj — Tue, 12 Dec 2023 22:50:19 GMT

Hello Userpath77,

Can you please try this:

Define the Cumulative Measure (CumulativeMeasure)
Define the Monthly Percentage Column (MonthlyPercentage)
Create a New Measure for the Percentage Calculation

PercentageOfCumulative = SUMX( 'YourTable', [CumulativeMeasure] * [MonthlyPercentage] )

SUMX iterates over each row, multiplying the CumulativeMeasure by the MonthlyPercentage for that row, and then sums these results.

Should you require any further assistance, please do not hesitate to reach out to me.

Re: Problem multiplying measure by column

Userpath77 — Wed, 13 Dec 2023 20:09:19 GMT

Thanks Sahir---I have a list of %'s that would need calculated for each month by the cumulative measure. Example, If year is 2024 and month is October, multiply cumulative measure by 10%. If year is 2023 and month is November, multiply cumulative measure by 20%. What is the best way to approach this?