Forum Discussion

vyogi's avatar
vyogi
Frequent Visitor
6 years ago
Solved

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 exa...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    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.