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.
Hi All,
I'm trying to create a calulated column like below and its not working for me.
Please advice what should be done in place of this.
Regards,
Himanshu
Solved! Go to Solution.
Finally came up with the below calculation which is somewhat as expected.
Hi,
You can try :
=TRUE() and =FALSE() instead of 1 and 0
Or as the yellow banner says use VALUE(YourColumn) instead of YourColumn directly.
and maybe remove UserName ?
or are you trying to concanate the results ?
In this case it shoud be :
UserName & "Watcher" or UserName & "Assignee" as a result in your formula.
Can you tell us more ?
Have already tried true/False its not working .
I'm trying to create a column where when the below condition meet it gives me "Assignee" and "Watcher"
Condition1 : isactive = 1 and then it should give me the username ( Which will be Assignee name)
Condition 2 : isactive = 0 and then also it should give username( which will be watcher)
OK so you should remove from your formula the "Watcher" and "Assignee".
It should be :
SWITCH (TRUE(),
IsActive = 1, "Assignee" & UserName,
IsActive = 0, "Watcher" & UserName,
"Not Existing")
Or it could be done in 2 different columns depends on your needs ?
Tell us if it works ?
I've already created individual columns
But the issue if when filtering the data , we've a value "NA" so it can be confusing for a user.
Finally came up with the below calculation which is somewhat as expected.
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 |
---|---|
107 | |
99 | |
76 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |