Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
102 | |
91 | |
84 | |
77 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |