Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
I got the solution
DIVIDE (SUM(TABLE[SALES], 100000) the result is in Lakhs
ex: DIVIDE(1800000, 100000) = 18 Lakhs
1M = 10Lakhs
I got the solution
DIVIDE (SUM(TABLE[SALES], 100000) the result is in Lakhs
ex: DIVIDE(1800000, 100000) = 18 Lakhs
1M = 10Lakhs
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.