Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Help with calculations

I need to create a line chart with monthl by month figures.  I get a report each month that I need to complete multiple steps in Excel to create this chart.  I want to be able to create this in Power...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

    I did this in two measures. Hope this helps!

    UnitTotal = SUMX('Table', 'Table'[L25]+'Table'[L27])

Monthly Total = 
VAR PrevMonthUnitTotal = CALCULATE([UnitTotal],
                         PREVIOUSMONTH('Table'[Report Date])
                         )
Return
IF(SELECTEDVALUE('Table'[This Month]) = "October",
    [UnitTotal],
    [UnitTotal]-PrevMonthUnitTotal
    
 )

     

    ~Kim

Anonymous's avatar
Anonymous
Not applicable
6 years ago

it looks like some of the other replies are calculating YTD amounts, but based on what you entered, it looks like it's already YTD and you're just trying to calculate the monthly amounts - right?

This is what I came out with.

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I want to thank you both for all the help today and so quickly.  This is a remarkable community and I'm learning so much from all of you.  I hope to pay it forward in the future.  Again, Thank you!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Agree 100% ! This is an amazing community!