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

az38's avatar
az38
Community Champion
6 years ago

Hi suman-petlu 

try

Column = SWITCH([t3189.w_xact_type_code],
"Standard Invoice", [t4720.loc_exchange_rate] * [t4720.net_amt],
"Invoice Cancellation" ,- 1 *[t4720.net_amt] *  [t4720.loc_exchange_rate],
0
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

  • 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

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Try using this inside switch sumx(sales[Amount_sold]*sales[Quantity_sold])

       

      Switch(times[calenderyear]="2000",sumx(sales[Amount_sold]*sales[Quantity_sold]))

    • 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