This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
I am trying to create a new conditional column with DAX using IF()
This does not seem to be working for me.
Below is my DAX query
And this is a screengrab of the results I got:
Can I get help with why the other conditions do not pull through?
Thanks!
Solved! Go to Solution.
You want to use 0,10 and 0,25.
because they are percentages. And power bi stores 25% as 0,25.
You want to use 0,10 and 0,25.
because they are percentages. And power bi stores 25% as 0,25.
@Anonymous That worked. Thanks!
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 45 | |
| 38 | |
| 24 | |
| 21 | |
| 20 |