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.
Dear Lovely Community,
I am having difficulty to create a conditional column, I would really appreciakte if you could help me in the formula (Conditonal Column (want to create this in Data view and not in Query editor) of powerBi Desktop.
So scenario is below
I have an Excel table consisting of four columns labeled "Sorted," "Preferred," "Enrolled," and "Expected." I'm looking to create a new conditional column called "result" based on the following criteria:
I have given an example below screen shot with the column that I want the results to be like.
Solved! Go to Solution.
I know that you don't want to do this in PQ. However, it will be easier to handle in PQ
pls see the attachment below
Proud to be a Super User!
I know that you don't want to do this in PQ. However, it will be easier to handle in PQ
pls see the attachment below
Proud to be a Super User!
Thank you very much for this solution 🙂
you are welcome
Proud to be a Super User!
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |