How to view SELECTCOLUMNS Table?

RYU209 — Wed, 18 Jan 2023 19:56:17 GMT

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.

Re: How to view SELECTCOLUMNS Table?

FreemanZ — Wed, 18 Jan 2023 23:15:28 GMT

hi RYU209

use the similar code like

Table = SELECTCOLUMNS(...)

to create a calculated table?

Re: How to view SELECTCOLUMNS Table?

v-yueyunzh-msft — Thu, 19 Jan 2023 02:48:22 GMT

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

Re: How to view SELECTCOLUMNS Table?

RYU209 — Thu, 19 Jan 2023 14:09:39 GMT

Thank you! This works perfectly.

topic How to view SELECTCOLUMNS Table? in DAX Commands and Tips

How to view SELECTCOLUMNS Table?

Re: How to view SELECTCOLUMNS Table?

Re: How to view SELECTCOLUMNS Table?

Re: How to view SELECTCOLUMNS Table?