Create a new table using columns from three other tables.

Question

Hello all,I have the following tables (columns), they are related by the column DATE:DIM_calendar (DATE)FACT_sales (DATE/PRODUCT/REVENUE)FACT_customers (DATE/#CUSTOMERS)&nbsp;I would like to create a new table AVERAGE TICKET (DATE/REVENUE/#CUSTOMERS).What options do I have to achieve this using DAX?Thank you! 🙂

selimovd · Accepted Answer

Hey&nbsp;gtrani&nbsp;,
&nbsp;
I'm not sure how the result should look like and what you want to do with that.
But the following caluclated table would create a table with the following combinations:
AVERAGE TICKET = 
SUMMARIZECOLUMNS(
    DIM_calendar[DATE],
    FACT_sales[Revenue],
    FACT_customers[#Cutomers]
)
&nbsp;
But I think you should explain a little bit better the purpose. I think the table above is not the best solution.
&nbsp;
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic

Forum Discussion

Create a new table using columns from three other tables.

1 Reply

Related content

Create new table

Lakehouse Table Generate Create Table

Create rows from 2 tables

Create columns group

Creating custom columns keeps returning a structured Table column