covert the the sales value from Million to indian lakhs in power bi

[NimaiAhluwalia]

Hello guys,

Can you give me an example like from how much I have to divide If my measure is SALES = SUM(TABLE[SALES)) which is showing in Millions how will I convert it in Lakh.

@amitchandak 

[NimaiAhluwalia · Accepted solution]

@v-janeyg-msft 

I got the solution 

DIVIDE (SUM(TABLE[SALES], 100000) the result is in Lakhs

ex: DIVIDE(1800000, 100000) = 18 Lakhs

1M = 10Lakhs

[v-janeyg-msft]

Hi,  @NimaiAhluwalia 

Do you want to perform currency conversion? What is the original currency unit? Your needs are not clear, Can you show some sample fake data and your desired result?

Best Regards

Janey Guo

[NimaiAhluwalia]

I want to convert $ to Indian currency which is from Million to lakhs.