Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
What do I need to do to fix this format/value error please?
Solved! Go to Solution.
Hi @rosscortb ,
You can modify your dax like this:
Column =
IF('Spans & Layers'[Direct Reports] > 10,"Red",
IF('Spans & Layers'[Direct Reports] >=1 || 'Spans & Layers'[Direct Reports] <= 2,"Red",
IF('Spans & Layers'[Direct Reports] >= 6 || 'Spans & Layers'[Direct Reports]<= 10,"Green",
IF('Spans & Layers'[Grade] in {"S1","S2","S3","S4"},"Black","Orange"))))
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rosscortb ,
You can modify your dax like this:
Column =
IF('Spans & Layers'[Direct Reports] > 10,"Red",
IF('Spans & Layers'[Direct Reports] >=1 || 'Spans & Layers'[Direct Reports] <= 2,"Red",
IF('Spans & Layers'[Direct Reports] >= 6 || 'Spans & Layers'[Direct Reports]<= 10,"Green",
IF('Spans & Layers'[Grade] in {"S1","S2","S3","S4"},"Black","Orange"))))
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Tahreem24 to be used in a conditional formating, and I need this formula due to the two columns
@rosscortb I tried formulate it as per my understanding. Try this out and let me know if it's giving you correct result or not.
Column = IF('Spans & Layers'[Direct Reports] > 10,"Red",IF('Spans & Layers'[Direct Reports] >=1 && 'Spans & Layers'[Direct Reports] <= 2,"Red",IF('Spans & Layers'[Direct Reports] >= 6 && 'Spans & Layers'[Direct Reports] <=10,"Green",IF('Spans & Layers'[Grade] = in {"S1","S2","S3","S4"},"Black","Orange"))))
@Tahreem24 it had errors with <= and then in.
So, changed to this but still has the value and format error as seen in my previous screenshot
@rosscortb little confused with your formula pattern. It's better if you could explain in a word or algorithm format.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
85 | |
84 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
97 | |
71 | |
67 |