Forum Discussion

Userpath77's avatar
Userpath77
Helper II
2 years ago

Problem multiplying measure by column

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?

Need Help

2 Replies

  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    Super User
    2 years ago

    Hello Userpath77,

     

    Can you please try this:

     

    1. Define the Cumulative Measure (CumulativeMeasure)
    2. Define the Monthly Percentage Column (MonthlyPercentage)
    3. 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.

    • Userpath77's avatar
      Userpath77
      Helper II
      2 years ago

      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?