Forum Discussion
Creating a ("derived") table w/atributes and aggregation func
I'm a database developer relatively new to PowerBI and the extensive DAX library. Im trying to understand whether or not I can generate a "derived table" from a table visualization I created. For example, I have a table viz with the following attributes and aggregation function - RanchNumber (tbl 1), Cycle (tbl2), Account (tbl3), and Amount (tbl4, SUM() aggregation function). These tables are all related. I have a similar data set from 3 tables and 2 aggregate functions (MAX() and MIN()).
I want to extend these data sets to their own tables for reference.
Ive been researching the issue but with more simplified scenarios using SUMMARIZE, SUMMARIZECOLUMNS - Im unclear about the aggregation part - not sure if these functions are the wrong direction or if I need nested functions. If nested, how to leverage the relationship?
Much gratitude for guidance in advanced.
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.
