Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Macro

I am a begginer is useing Power BI and DAX. I need to substruct within one column. The column is called "DR" and has only DR08 and DR07, but this will be growing each month, so next month I will have...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous I would recommend unpivoting those columns. Then you can construct a measure that finds the maximum value in the Attribute column and subtract it from the previous latest one.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous I would recommend unpivoting those columns. Then you can construct a measure that finds the maximum value in the Attribute column and subtract it from the previous latest one.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    This worked great. Thank you!