Forum Discussion

tegar-budi's avatar
tegar-budi
Frequent Visitor
6 years ago

Dax Measure using IF statement with Values Function

  Hello,   I have table source like   I want to change value to USD Rate using a measure for my report. I can use a calculated column but i have 120 val column, it will make my report loa...
if condition
if statement
Measures
values
camargos88's avatar
camargos88
Community Champion
6 years ago

Hi tegar-budi ,

 

I used Power Query to unpivot all the values colums and create another custom column to convert the values IDR

 

You can check it on this file as an example: Download PBIX 

 

Ricardo