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
Anonymous - Yes, I do it all the time. You just specify a VAR and set that equal to your table equation/filter. Then you can use it within a measure.
Thank you Greg for the swift response. Can I use VAR in "PowerPivot for excel"/Data Model window in calculation area(measures) section? could you please also give some examples. Thank you.