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

[suman-petlu]

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 t3189.w_xact_type_code = 'Invoice Cancellation' THEN
t4720.net_amt * - 1 * t4720.loc_exchange_rate
END

Thanks in advance
Suman

[amitchandak]

The above solution will help.

Also Refer :

https://docs.microsoft.com/en-us/dax/switch-function-dax

https://community.powerbi.com/t5/Desktop/Help-with-SWITCH-TRUE-with-multiple-items-to-evaluate/td-p/...

[az38]

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]

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 · Accepted solution]

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

[amitchandak]

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

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