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.
Hi everyone,
I'm facing an issue with my Power BI desktop today,
Basically I have 2 Excel spreadsheets, one with an actual revenu and one with the target revenue.
I can create a relationship between the tables and everything but in one spreadsheet numbers are written in millions ($2.900.000) and in the other spreadsheet my target is written as 218.5 (M$). So my target is invisible if I create a graph and it doesn't make any sense.
I'm not allowed to change anything in the spreadsheets so I was wondering if there is a formula to convert my target to millions in Power BI ?
Thanks,
Sure,
let splitColumn1 = Splitter.SplitTextByDelimiter(" (", QuoteStyle.None)([Column1]), splitsplitColumn10 = Splitter.SplitTextByDelimiter(".", QuoteStyle.None)(splitColumn1{0}?) in Text.Combine({Text.Combine(splitsplitColumn10), "00000"})
BTW, I used "Column from Examples" to get this formula, worked!!
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.
User | Count |
---|---|
107 | |
98 | |
77 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |