Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Solved! Go to 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
The above solution will help.
Also Refer :
https://docs.microsoft.com/en-us/dax/switch-function-dax
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
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
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
Try using this inside switch sumx(sales[Amount_sold]*sales[Quantity_sold])
Switch(times[calenderyear]="2000",sumx(sales[Amount_sold]*sales[Quantity_sold]))
User | Count |
---|---|
98 | |
89 | |
82 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |