I need output to be display for only selected countries along with the currency Type beside the amount like 5000 USD, Pls correct below code Currency Type = IF( HASONEVALUE('CURRENCY'[country]), CONCATENATEX(VALUES('CURRENCY'[country]), FORMAT(SUM(SALES[SALES]), "Currency"), ",") & " " & SELECTEDVALUE('CURRENCY'[Currency]))
@POWERBIWITHPRASAD Thank you for your video. Can you provide the same video but using 4-4-5 calendar (ISO). I tried to use the approach that you show here in the video but standard DAX functions didn't help. Probably Power Query can help but I didn't find how to get weeknumber there.
Nice … but can we compare two measures columns.. u have taken measure as a column values right.. Let’s say one more column with measures as a column.. my question is can we compare those 2 columns like finding difference etc ….