DAX for selecting all of the columns and data within a table

ClemFandango — Tue, 14 Nov 2023 07:52:11 GMT

Hi all,

I am hoping someone can help? I have a bit of a DAX problem (hey who doesn’t)…

I have quite a complicated Power Automate Flow that takes the output from a PBI query, saves it into sharepoint by splitting and joining multiple files, which allows me to automate an extract of 100,000+ rows into CSV.

My flow works fine, except for the DAX within the ‘Run a query against a dataset’ flow. All I want to do is export the contents of the table ‘Help’. The DAX in my examples work on columns that contain numbers, but it appears to fail if I add a column that contains a String like I have in 'Help’ [Test4], 'Help’ [Test5] 'Help’ [Test6]. If i add 'Help’ [Test3] (which is numeric) to the code below it will work.

I would like to use DAX to select all the columns in my table (about 35+)

// DAX Query DEFINE VAR __DS0FilterTable = // Removes repeat headers FILTER(KEEPFILTERS(VALUES('Help’[Index])), and('Help’ [Index] >= @{variables('MinRows')}, 'Help’ [Index] <= @{variables('IncrRows')})) // Export content of table VAR __DS0Core = CALCULATETABLE( SUMMARIZECOLUMNS( 'Help’[File.Name], 'Help’ [Index], 'Help’ [Test1], 'Help’ [Test2]), __DS0FilterTable ) EVALUATE __DS0Core ORDER BY ‘Help’[Index]

Eternally grateful for any help!

Re: DAX for selecting all of the columns and data within a table

lbendlin — Sat, 18 Nov 2023 01:25:02 GMT

Your sample code uses funny single quotes.

topic DAX for selecting all of the columns and data within a table in DAX Commands and Tips

DAX for selecting all of the columns and data within a table

Re: DAX for selecting all of the columns and data within a table