Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
How can I visualize the table created by the SELECTCOLUMNS function? I'd like to make sure that my function is behaving as intended.
Solved! Go to Solution.
Hi , @RYU209
Based on my understanding of your requirements description, it seems that you have defined a virtual table using Var virtual in a DAX expression, but are not sure what its output value is, and want to visualize it to determine the output and verify before doing the next step, right? If this is the case, you can try to directly create an entity calculation table, and display the Var virtual definition of a virtual table to ensure that it is correct before doing the next step, which is also a very practical trick for our DAX developers to debug code when doing these complex DAX logic development.
For the DAX function you use SELECTCOLUMNS, it can be used to return a table with selected columns from the table and new columns specified by the DAX expressions, if you still have any difficulties and need help, you can refer to this official document first:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi , @RYU209
Based on my understanding of your requirements description, it seems that you have defined a virtual table using Var virtual in a DAX expression, but are not sure what its output value is, and want to visualize it to determine the output and verify before doing the next step, right? If this is the case, you can try to directly create an entity calculation table, and display the Var virtual definition of a virtual table to ensure that it is correct before doing the next step, which is also a very practical trick for our DAX developers to debug code when doing these complex DAX logic development.
For the DAX function you use SELECTCOLUMNS, it can be used to return a table with selected columns from the table and new columns specified by the DAX expressions, if you still have any difficulties and need help, you can refer to this official document first:
SELECTCOLUMNS function (DAX) - DAX | Microsoft Learn
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you! This works perfectly.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
42 | |
37 | |
22 | |
22 | |
21 |