Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Help please
this is the data
User_ | Induction complete_ | Test name_ | Test result_ |
Bill | True | A | Pass |
Bill | True | B | Pass |
Bill | True | C | Fail |
Sue | False | A | Pass |
Sue | False | C | Pass |
result needs to look like,
User | Action |
Bill | Test A Passed |
Bill | Test B Passed |
Bill | Retake test C |
Sue | Complete Induction |
Sue | Complete Induction |
thanks
Solved! Go to Solution.
Hi @rafterse
Thanks for the reply from @sanalytics .
If your problem has not been resolved, try the following:
Create a calculated column as follow
Action =
IF (
[Induction complete_] = "False",
"Complete Induction",
IF (
[Test result_ ] = "Pass",
"Test " & [Test name_] & " Pass",
"Retake test " & [Test name_]
)
)
Create a calculated table as follow
Table 2 = SELECTCOLUMNS('Table', "User_", [User_], "Action", [Action])
Result:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rafterse
Thanks for the reply from @sanalytics .
If your problem has not been resolved, try the following:
Create a calculated column as follow
Action =
IF (
[Induction complete_] = "False",
"Complete Induction",
IF (
[Test result_ ] = "Pass",
"Test " & [Test name_] & " Pass",
"Retake test " & [Test name_]
)
)
Create a calculated table as follow
Table 2 = SELECTCOLUMNS('Table', "User_", [User_], "Action", [Action])
Result:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
looks like the file has expired
Sorry for the inconvenience.
It is some kind of shame of the Microsoft and the dark side of this community rules restrict some users from attaching PBIX files directly to their posts, while others can. This inconsistency forces us to resort to external links for file sharing, which can be frustrating.
All contributors on this platform are working professionals dedicating extra time outside of their jobs to enhance their skills and help others. It would be beneficial if Microsoft could provide all users, including new contributors, with the option to share files directly.
Such a change would promote a more inclusive and efficient environment for knowledge sharing and collaboration within the community.
Regards
sanalytics
Hello @rafterse
Please find the below pbix file for your output.
https://dropfiles.org/a6Tgg9LI
Hope it will help you.
Regards
sanalytics
If it is your solution then please like and accept it as solution
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |