How to create a RATE table for Table from Indonesia amount need to divide by 10,000

[Anonymous]

Hi All

May i know how to create a RATE table , So that when Source.Name=INVC_TI.CSV it will divide by 10,000 ?

My PBI file :-

https://www.dropbox.com/s/v0d5shvm6w72rv4/INVC_V003.pbix?dl=0

Paul

[themistoklis]

@Anonymous 

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])

[Anonymous]

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

Hello @Anonymous 

The measure you should be like this:

Measure = DIVIDE ( [AMOUNT],MAX('RATE'[RATE]))

[Anonymous]

Hi Themistoklis

Yes , this is the correct approach.

Thank you very much.

paul Yeo

[aj1973]

Here you go @Anonymous