Forum Discussion

gonnelli's avatar
gonnelli
Frequent Visitor
7 years ago
Solved

Difference between 2 rows using first row fixed

Hello!   I need to calculate the difference between two rows in a matrix table in Power BI, but I need to keep the first row as reference, like this:   EDIT: The first row (Model "A") can be chan...
General Comment
Need Help
Tips and Tricks
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi gonnelli,

     

    Does that make sense? If so, kindly mark my answer as a solution to close the case.


    Regards,
    Frank

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

 

Do you want to take the difference between the price in the current row and the row with the minumum price?

gonnelli's avatar
gonnelli
Frequent Visitor
7 years ago

Hi Ashish_Mathur!

 

I need to calculate always the first rows and another rows, but the first rows can be changed by filter.