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.
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
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |