Forum Discussion
Anonymous
8 years agoNot applicable
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...
- 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.
- Anonymous8 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.
Much appreciated,
Tamir
Anonymous
8 years agoNot applicable
Because of the 30K limitations. I have 500K records
Greg_Deckler
Community Champion
8 years agoOh yeah. Good point!