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.
I'm able to achieve the following in SQL with a union all and where clause, but would like to be able to do this in PowerBI
Solved! Go to Solution.
You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
After hours of trial and error with union and selectcolumns function, I was able to find a solution using your suggestion. Thanks for putting me on the right track.
@v-chuncz-msft wrote:
You may use SELECTCOLUMNS Function (DAX) and UNION Function to add a calculated table.
Hi Sam,
This puts me in the right direction, but after spending some time googling, I'm stilll having trouble getting the desired results. Could you elaborate a little more? Any help is greatly appreciated. Thanks
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |