Forum Discussion

dancarr22's avatar
dancarr22
Helper V
8 years ago
Solved

Calculate the difference between two columns (without hard coding in formula) in matrix

Hello,   We have tickers for which we receive prices from multiple vendors on a daily basis. i.e. We receive prices from 4 vendors for ticker ABC.                 We would like to sh...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi dancarr22,

     

    Index column is a custom column I created in query edit.

     

    Since power bi data model not contains column index and row index, you need one index to let formula calculation dynamic based on current index.(such current -1 or current +1)

     

    Date or numeric column can be used as index, text character current not support compare with math symbols.

     

    If you only need to calculate on specific source, you can try to use switch function to define them as specific numeric as calculation index.

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi dancarr22,

 

Index column is a custom column I created in query edit.

 

Since power bi data model not contains column index and row index, you need one index to let formula calculation dynamic based on current index.(such current -1 or current +1)

 

Date or numeric column can be used as index, text character current not support compare with math symbols.

 

If you only need to calculate on specific source, you can try to use switch function to define them as specific numeric as calculation index.

 

Regards,

Xiaoxin Sheng

dancarr22's avatar
dancarr22
Helper V
7 years ago

Thanks Xiaoxin