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?
Go to Solution.
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.
View solution in original post
Thanks for your advice, I will use it accordingly (in DAX).
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!