Forum Discussion
Solved
Create summarized table
Hello all, I got two tables with order data (ecom/retail). My goal is to create a summarized table (based on the email address) that looks like Table 3. Table 1 & 2 has a lot of columns, below ...
Hi andersbq ,
You could do this in Query Editor with Merge, Append, Group by and Remove duplicates features.
Pbix as attached.
Best Regards,
Jay
andersbq , refer if this can help
https://www.sqlbi.com/articles/from-sql-to-dax-joining-tables/
Try like
summarize(
union (
selectcolumns(Table1,"Email",Table1[Email] ,"Name",Table1[Name],"Order ID",Table1[Order ID],"Product ID",Table1[Product ID],"Order date",Table1[Order date]),
selectcolumns(Table2,"Email Name",Table2[Email] ,"Name",Table2[Name],"Order ID",Table2[Order ID],"Product ID",Table2[Product ID],"Order date",Table2[Order date])
), [Email],[Name],"First order" ,min([Order date]),"Latest order",max([Order date]))
Thanks! amitchandak - but I get this error message: Cannot identify the table that contains [Order date] column.