Forum Discussion
Anonymous
4 years agoNot applicable
Calculated Tables Advice
Earlier Opening Opportunity Mon-Fri Summary Table =
FILTER (
SUMMARIZECOLUMNS (
'Earlier Opening Opportunity Mon-Fri Detail Table'[ShopKey],
"Net Sales Ex Vat", (SUM ( 'Earlier ...
m3tr01d
Continued Contributor
4 years agoAnonymous
The questions you need to ask yourself is do you really need to do a Calculated table for your usecase?
The problem is we don't know what you want to do.
90% of the time, you don't need to build a Calculated Table and 95% of the time, you don't even need to know the function SummarizeColumns / Summarize.
- Explain to us the different tables of your model and the relationship
- Give us an example of the final output you want to have (maybe with an excel table)
Then, we can discuss about the possibilities