Forum Discussion

nrenaud's avatar
nrenaud
Helper I
6 years ago
Solved

Percent Change between 2 columns on a Matrix

I am trying to create a measure (or possibly multiple measures) that will show the percent change between 2 years, for multiple sets of data. Is this something that is possible with DAX? The problem ...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi nrenaud ,

     

    Please kindly check the attachment whether help.

     

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Community Support
6 years ago

Hi nrenaud ,

 

Please kindly check the attachment whether help.

 

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

nrenaud's avatar
nrenaud
Helper I
6 years ago

Icey Do you happen to know if there is a way to assign currency to the Billings line? I tried the following in the measure, however it did not seem to work in the matrix:

CurrentYear Value = SWITCH ( MAX ( 'Column/Measure Name'[Measure Name] ),
    "Billings", CURRENCY(SUM ( EnergyMetrics[Billings] ))
 
I have also assigned the column as currency.
 
Thanks, appreciate the assistance!