How to view SELECTCOLUMNS Table?

[RYU209]

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. 

[v-yueyunzh-msft · Accepted 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

[RYU209]

Thank you! This works perfectly. 

[FreemanZ]

hi @RYU209 

use the similar code like

Table = SELECTCOLUMNS(...)

to create a calculated table?