Forum Discussion

SteelChampzz's avatar
SteelChampzz
Helper II
3 years ago
Solved

Multiple Two Columns then return an IF statement

I want to use this EXCEL formula in Power BI   "=IF(O2>0,O2*M2,M2)" or "=IF(P2>0,J2*P2,"")"   So lets say O2 & P2 are "Quanities"    M2 & J2 are "Units" I want to make sure that those number val...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi SteelChampzz,

    AFAIK, the current power bi data model table does not include the row and column index.
    So if you want to calculate with specific row records, please add an index field in the table as a condition to help DAX expressions find the corresponding records to calculate.

    Add an index column (Power Query) (microsoft.com)

    If you only mean to calculate values based on condition, you can add a calculated column to the table:

    Column formula =
IF ( Table[Column1] > 0, Table[Column1] * Table[Column2], Table[Column2] )

    BTW, current power bi does not support creating dynamic calculated columns/tables based on filter effect. They are working on different levels and you can't use the child level to affect their parent.

    Regards,

    Xiaxoin Sheng

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi SteelChampzz,

AFAIK, the current power bi data model table does not include the row and column index.
So if you want to calculate with specific row records, please add an index field in the table as a condition to help DAX expressions find the corresponding records to calculate.

Add an index column (Power Query) (microsoft.com)

If you only mean to calculate values based on condition, you can add a calculated column to the table:

Column formula =
IF ( Table[Column1] > 0, Table[Column1] * Table[Column2], Table[Column2] )

BTW, current power bi does not support creating dynamic calculated columns/tables based on filter effect. They are working on different levels and you can't use the child level to affect their parent.

Regards,

Xiaxoin Sheng