https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3270473#M121195 <P>I am using select columns and storing 2 columns in that selectcolumns table</P><P>then i am storing that into a variable.</P><P>how can i access onlyone column out of it.?</P><P>&nbsp;</P> Tue, 06 Jun 2023 12:40:22 GMT Anonymous 2023-06-06T12:40:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3270473#M121195 <P>I am using select columns and storing 2 columns in that selectcolumns table</P><P>then i am storing that into a variable.</P><P>how can i access onlyone column out of it.?</P><P>&nbsp;</P> Tue, 06 Jun 2023 12:40:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3270473#M121195 Anonymous 2023-06-06T12:40:22Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3270498#M121196 <P>Anonymous</LI-USER>&nbsp;Couple different ways. You could use another SELECTCOLUMNS. Also, you can use an X aggregator, MAXX, MINX, SUMX, etc.</P> Tue, 06 Jun 2023 12:49:51 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3270498#M121196 Greg_Deckler 2023-06-06T12:49:51Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3270531#M121197 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="313" data-lia-user-login="Greg_Deckler" class="lia-mention lia-mention-user">Greg_Deckler</a>&nbsp;thanks using another selectcolumn works</P> Tue, 06 Jun 2023 12:58:07 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3270531#M121197 Anonymous 2023-06-06T12:58:07Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3279805#M121800 <P>is there a way we can restrict the blank values during fectching data using selectcolumns.</P> Mon, 12 Jun 2023 15:00:42 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Selectcolumns/m-p/3279805#M121800 Anonymous 2023-06-12T15:00:42Z