Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NimaiAhluwalia
Responsive Resident
Responsive Resident

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

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 

1 ACCEPTED SOLUTION
NimaiAhluwalia
Responsive Resident
Responsive Resident

@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

View solution in original post

3 REPLIES 3
NimaiAhluwalia
Responsive Resident
Responsive Resident

@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
Community Support
Community Support

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

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors