Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm wondering if it's possible to create a slicer which has results of an IF statement in. This is the IF statment
Spread Outcome = IF([Spread Offer Low] = [Final Option Price]&&[Spread Offer High]=[Final Option Price], "Fixed", IF([Average Sum] >= [Final Option Price], "Low", IF([Average Sum] < [Final Option Price], "High")))
And I want to create a slicer with "Low", "High", Fixed", just like so...
Thanks,
Mike
Solved! Go to Solution.
Only column can be used in a slicer, so you should convert this measure into calculate column.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Only column can be used in a slicer, so you should convert this measure into calculate column.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |