How to convert foreign currency X Rate = SGD amount ?

[admin11]

Hi All

I need to compute net profit in SGD = net profit X rate 

I try below , it return wrong value :-:-

_YTD_NET_PROFIT_SGD = DIVIDE([_YTD_NET PROFIT_C] , [_rate_AR],BLANK() )

Below is my PBI file :-

https://www.dropbox.com/s/3x0zq00lq3q7s4o/PBT_V2021_392%20TI_SI_GL%20how%20to%20compute%20net%20prof...

Paul

[PhilipTreacy]

@admin11 

Hi Paul,

Download PBIX

Is the calculation Net Profit X Rate or Net Profit / Rate ?

Try this measure if you multiply them

_YTD_NET_PROFIT_SGD = [_YTD_NET PROFIT_C] * SELECTEDVALUE('RATE'[RATE])

or this if you divide

_YTD_NET_PROFIT_SGD = DIVIDE([_YTD_NET PROFIT_C], SELECTEDVALUE('RATE'[RATE]))

Regards

Phil

[admin11]

@PhilipTreacy 

Thank you very much , it work fine , But it does not give Overall Total amount , i recall i need to add SMUX , i try below :-

_YTD_NET_PROFIT_SGD = SUMX(DIVIDE([_YTD_NET PROFIT_C] , [_rate_AR],BLANK() ))

it does not work.

Paul

[Ashish_Mathur · Accepted solution]

Hi,

This measure works

Measure 4 = SUMX(VALUES('RATE'[SOURCE]),[YTD_NET_PROFIT_SGD])

Hope this helps.

[admin11]

@Ashish_Mathur 

Thank you very much.

Paul

[Ashish_Mathur]

You are welcome.