Creating a table from a table visualization

Hello,

I have a table visualization that has a few columns based on DAX measures.

It has 500K records.

I would like to export it to a CSV and would be happy to use the DAX stdio.

But...How do I "convert" the table visualization into a "regular" table to which I could query in the DAX studio?

Thanks,

Tamir

Greg_Deckler
8 years ago
Sure, you would go into Modeling tab and then do a New Table. But, I would need to understand your source data and what you are doing in your table visualization. But, in theory it should just be something that uses the SUMMARIZE function.

https://msdn.microsoft.com/en-us/library/mt163696.aspx
Anonymous
8 years ago
Thank you!

That is precisely what I needed.
I did:

CostTable = SUMMARIZECOLUMNS(factsSalaries[Employee ID], factsSalaries[Employee Name],dimCalendar[MonthYear], "Cost USD", [TotTSAUSD])

and then with DAX Studio could extract the table into a CSV file.
(http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax-studio-methods/)

Much appreciated,
Tamir

Forum Discussion