Forum Discussion
How to create a RATE table for Table from Indonesia amount need to divide by 10,000
Hello Anonymous
The measure you should be like this:
Measure = DIVIDE ( [AMOUNT],MAX('RATE'[RATE]))
Community ChampionAnonymous
Best to create an excel file with all the conversaion rates.
In your case the table will have at least 2 fields:
First field will be Source_Name (e.g. INVC_TI.csv) and second field will be the Rate.
Load the excel file to PowerBI and on Model section, join the excel table with the main table on Source_Name field (many to one cardinality)
Then create a measure which will simply divide the Amount with the Rate (e.g. Measure = DIVIDE([Amount], [Rate])
Hi Themistoklis
Yes , this is the correct approach.
Thank you very much.
paul Yeo
Hi Themistoklis
I have follow your instruction , a;ready create a RATE table , now when i try to create an expression i get error :-
https://www.dropbox.com/s/haz2vclxrqg0yy3/INVC_V005.pbix?dl=0
Above is my PBI file
Paul
- themistoklis
Hello Anonymous
The measure you should be like this:
Measure = DIVIDE ( [AMOUNT],MAX('RATE'[RATE]))