Forum Discussion

suman-petlu's avatar
suman-petlu
Frequent Visitor
6 years ago
Solved

How to create measure columns using case statement based on condition in power bi

Hi all, I am new to power bi,please let me know how to execute below case statement CASE WHEN t3189.w_xact_type_code = 'Standard Invoice' THEN t4720.loc_exchange_rate * t4720.net_amt WHEN t31...
Need Help
Show and Tell
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    Please try IF dax function:

    Column = IF(RELATED('Table 2'[Date].[Year])=2000,'Table'[Amount]*'Table'[Quantity])

    And it shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

suman-petlu's avatar
suman-petlu
Frequent Visitor
6 years ago

Hi az38 ,

 I tried using Switch function but i didn't get desried results.Please help

 

But tried to multiply with Constant value ,its working as expected

 

Regards,

Suman

v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please try IF dax function:

Column = IF(RELATED('Table 2'[Date].[Year])=2000,'Table'[Amount]*'Table'[Quantity])

And it shows:

Hope this helps.

 

Best Regards,

Giotto Zhi