Forum Discussion
How to create a RATE table for Table from Indonesia amount need to divide by 10,000
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 ...
Hello Anonymous
The measure you should be like this:
Measure = DIVIDE ( [AMOUNT],MAX('RATE'[RATE]))
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
Hello Anonymous
The measure you should be like this:
Measure = DIVIDE ( [AMOUNT],MAX('RATE'[RATE]))