Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All, I have a calculated column (see below) to calculate a percent from two numbers of other columns.
Now I'd like to create another column to display if the percent is greater than 70%. Just not sure how to write the DAX for it, if someone could help. Thanks.
Solved! Go to Solution.
Hi,
In your DAX calculation do not use % sign, only use decimal version. Instead of 20% use 0.2 etc.
Example here:
Hi,
In your DAX calculation do not use % sign, only use decimal version. Instead of 20% use 0.2 etc.
Example here:
Ahh, I had .7 rather 0.7 earlier.
Thanks Migasuke, appreciate that. Cheers.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
88 | |
81 | |
60 | |
60 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |