01-04-2018 08:29 PM
The solution for your problem can be released by using Union and Selectcolumns Function:
Union( selectcolumns(Table A,"Opening_Date", Table A[Opening_Date], "Store_Name", Table A[Store_Name],"Store_Number", Table A[Store_Number]), selectcolumns(Table B,"Business_Date", Table B[Business_Date], "Location", Table B[Location],"Location_Code", Table B[Location_Code]) )
You should try this way.
11-28-2018 03:22 AM
The simplest way I found was to use the DAX - Union (Selectcolumns(), Selectcolumns())
Here you can select the tables, individual columns as well as rename those columns on the fly for the Union funciton to combine the dataset together.