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.
I am (re)building a dataset and report from an Excel sheet that I download. There are columns that are supposed to be rates, i.e. number of new visits coded X/total number of new visits. Unfortunately, these are all formated as numbers rather than percentages. So, for example, where a code utilization rate is listed as 19.04, it should really be 19.04%, or 0.1904. See image:
Is there a way I can transform these values to be correct, either within Power Query or through DAX? I don't want to do it in the source file because that will take some work and I am trying to set this up so that I can just add future files into the source folder to update it.
Note that I can't just make them data type: percentage because, using my previous example, 19.04 will become 1904% rather than 19.04%. This matters for some other calculations, conditional formating, and displaying the values correctly as percentages.
Solved! Go to Solution.
Hi,
The picture should say it all
Hi,
The picture should say it all
Perfect, thatnks!
You are welcome.
@cathoms maybe add another column and divide the value by 100 and then remove old columns:
New Column = [Column]/100
you have to add new column for each column that need transformation.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |