Forum Discussion

Natty004's avatar
Natty004
Frequent Visitor
4 years ago
Solved

Calculating % increase as dollar value - DAX

Hello,   I'm relatively new to powerBI and I'm trying to calculate the actual $ amount of margin increase compared to the margin % last month, and I'm struggling with the DAX (Therefore as we have ...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Natty004 

    Please try

    Prior Month % =
CALCULATE (
    [Measure : Margin %],
    Table1[YearMonth Sequential Number]
        = MAX ( Table1[YearMonth Sequential Number] ) - 1,
    ALL ( Table1[Year & Month] )
)
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Natty004 

Please try

Prior Month % =
CALCULATE (
    [Measure : Margin %],
    Table1[YearMonth Sequential Number]
        = MAX ( Table1[YearMonth Sequential Number] ) - 1,
    ALL ( Table1[Year & Month] )
)
Natty004's avatar
Natty004
Frequent Visitor
4 years ago

Thank you tamerj1 - your assitance is greatly appreciated