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.
Can anyone explain to me why I can't use this column?
And how I can change the measure?
anyone?
Hi @asfasfgasfg ,
According to your description and the provided dax logic, you are trying to realize that if "LCM EC EXCEL"[RWS] is null, then this formula will return "OWB", otherwise "RWS ". In your formula, what you are returning after isblank is a boolean value and what you are comparing is a text value. To accomplish this while making sure your data type is text, here is a modification to your dax expression:
RWS/OWB = IF(
ISBLANK('LCM EC EXCEL'[RWS]),
"OWB",
"RWS"
)
Best regards,
Albert He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The column [RWS] is filled with RWS and many other values. I have no null values.
User | Count |
---|---|
82 | |
76 | |
71 | |
69 | |
54 |
User | Count |
---|---|
105 | |
100 | |
91 | |
79 | |
68 |