Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Power BI Community,
I need a help with appending two tables together.
What I would like to do is to append a calculated column from one table to another.
In the attached BI, I have "Demand" table.
In it, I calculated gross sales as a calculated column as below screenshot.
(Demand cab)
In PL by SKU table, I have actual gross sales data as per below.
I would like to append these two tables including "demand cab" calculated column
and sort out by "SKU name Final", which is in "SAP Code Mapping" table.
The relationship is already created.
I would like to have a new table with SKU Name Final and gross sales information.
then I would like to put other calculated columns in the new table to calculate down to net sales.
If you can help with this, this is much appreciated.
Many thanks,
H
Solved! Go to Solution.
Hi @hidenseek9,
I get it now. Try these table formulas, please.
Table = DISTINCT ( UNION ( SELECTCOLUMNS ( Demand, "SKU Name Final", [SKU Name Final], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [Demand Cab] ), SELECTCOLUMNS ( 'PL by SKU', "SKU Name Final", [SKU NAME], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [GS - Gross Sales] ) ) )
Or,
Table = UNION ( SELECTCOLUMNS ( Demand, "SKU Name Final", [SKU Name Final], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [Demand Cab] ), SELECTCOLUMNS ( 'PL by SKU', "SKU Name Final", [SKU NAME], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [GS - Gross Sales] ) )
Best Regards,
Dale
Hi @hidenseek9,
Is the NEW table in the snapshot what you'd like? Please don't share sensitive data due to it's public here.
Table = ADDCOLUMNS ( SUMMARIZE ( 'SAP Code Mapping', 'SAP Code Mapping'[SKU Name Final] ), "Gross Sales", CALCULATE ( SUM ( 'PL by SKU'[GS - Gross Sales] ) ), "Demand cab", CALCULATE ( SUM ( Demand[Demand Cab] ) ) )
Best Regards,
Dale
Thank you for your quick response.
What I would like to achieve is that,
Sorry I was not clear.
Basically, "Demand cab" from Demand tab is gross sales and Gross Sales from PL by SKU tab is gross sales,
so I would like to bring both of them in one column.
Many thanks,
H
Hi @hidenseek9,
I get it now. Try these table formulas, please.
Table = DISTINCT ( UNION ( SELECTCOLUMNS ( Demand, "SKU Name Final", [SKU Name Final], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [Demand Cab] ), SELECTCOLUMNS ( 'PL by SKU', "SKU Name Final", [SKU NAME], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [GS - Gross Sales] ) ) )
Or,
Table = UNION ( SELECTCOLUMNS ( Demand, "SKU Name Final", [SKU Name Final], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [Demand Cab] ), SELECTCOLUMNS ( 'PL by SKU', "SKU Name Final", [SKU NAME], "Date", [Date], "Sequence", [Sequence], "Gross Sales", [GS - Gross Sales] ) )
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |