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,
I would like to combine some data from 2 differents tables in direct query mode.
The objective is to get sales from table 2 to table 1, for only 1 specific shop (see example below).
I tried Amend function but not working in direct query mode.
And merge doesn't seems my solution since in reality, my tables headers are different.
Do you have any other suggestion?
Thank you!
Example :
Solved! Go to Solution.
Hi @Anonymous,
Do you have the latest version of Power BI Desktop? You can append the queries in the Query Editor after changing the column names.
Another solution is using DAX. Maybe this one like below.
Table = UNION ( SELECTCOLUMNS ( st2, "Date", [Date], "Day", [Dayz], "Month", [Month], "Value", [Value], "Year", [Year] ), SELECTCOLUMNS ( table2, "Date", [date2], "Day", [Dayz], "Month", [Month], "Value", [Value], "Year", [year2] ) )
Best Regards,
Even Union in DAX create table in import mode. I need the resultant table to be in direct query mode only @v-jiascu-msft
Hi @Anonymous,
Do you have the latest version of Power BI Desktop? You can append the queries in the Query Editor after changing the column names.
Another solution is using DAX. Maybe this one like below.
Table = UNION ( SELECTCOLUMNS ( st2, "Date", [Date], "Day", [Dayz], "Month", [Month], "Value", [Value], "Year", [Year] ), SELECTCOLUMNS ( table2, "Date", [date2], "Day", [Dayz], "Month", [Month], "Value", [Value], "Year", [year2] ) )
Best Regards,
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 |
---|---|
111 | |
97 | |
82 | |
67 | |
61 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |