Forum Discussion
Creating a ("derived") table w/atributes and aggregation func
Hi vyogi ,
1. If you want to sellect different columns and measures from different tables to generate a new calculated table, you can use SUMMARIZE or SUMMARIZECOLUMNS. And this post may be a bit helpful too.
2. If you want to add calculated columns to the given table or table expression, you can use ADDCOLUMNS.
3. If you want to create a table with the Cartesian product, you can use GENERATE.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Icey , Yes, Id like to convert the visualizations to tables; I suppose this would be a "calculated table" which is a new concept for me.
Example of data for first table is Ranch.RanchNumber, Cycle.CycleDesc, Max Date (measure), Min Date (Measure). Measures are simple and straight forward: Max Date = MAX(Production[week ending]) and Min Date = Min(Production[week ending])
Community SupportHi vyogi ,
1. If you want to sellect different columns and measures from different tables to generate a new calculated table, you can use SUMMARIZE or SUMMARIZECOLUMNS. And this post may be a bit helpful too.
2. If you want to add calculated columns to the given table or table expression, you can use ADDCOLUMNS.
3. If you want to create a table with the Cartesian product, you can use GENERATE.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for the responses and help Icey