Forum Discussion
Creating a table from a table visualization
- 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
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.
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