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 have a custom column driven with multipe IFs and one condition is not being met even though the data is correct. It is a Percent Type while all others are either Whole or Decimal Number types. This has driven me semi crazy for a couple of days trying to figure out why this one IF statement is not working. Any and all help would be much appreciated. My model and data is available if needed. Thanks in advance.
Solved! Go to Solution.
Is your measure formatted as a whole number? If so 11.85% = .1185 which may be getting rounded down to 0.
Is your measure formatted as a whole number? If so 11.85% = .1185 which may be getting rounded down to 0.
Link to shared google drive with model and source, if needed.
https://drive.google.com/drive/folders/1JxF68SxrkJOg-3u9cEFkG550LhorG5b-?usp=sharing
I could zip up the model and data sources and hang them out on my shared drive if that would help ?
It is a percentage type at the source and in the model, too.
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 |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |