Forum Discussion

SachinC's avatar
SachinC
Helper V
9 years ago
Solved

DAX Append Query - Merging Data

Hi, I have an Excel workbook with reference data - i.e. Days of the Year, Week#, Month# etc... Other tabs bear data for certain processes, i.e. Sales etc.. which are date related. I want to use a ...
Need Help
  • SachinC's avatar
    SachinC
    9 years ago

    Hi,

    So I used the Append Query. I made sure my date fields in my data source were broken down for Day/Week/Month/Year for each tab in my Excel Spreadsheet. I then used the append query by making sure the date, i.e. week (as I wanted all data to be by week) was joined and replicated for all tabs so that the append query (mash up of all Excel tabs) was consistent. The Append Query then showed all fields across all tabs in my Excel sheet.  This then enabled me to add slicers for Week in my report. 

    Thanks.

SachinC's avatar
SachinC
Helper V
9 years ago

Hi,

So I used the Append Query. I made sure my date fields in my data source were broken down for Day/Week/Month/Year for each tab in my Excel Spreadsheet. I then used the append query by making sure the date, i.e. week (as I wanted all data to be by week) was joined and replicated for all tabs so that the append query (mash up of all Excel tabs) was consistent. The Append Query then showed all fields across all tabs in my Excel sheet.  This then enabled me to add slicers for Week in my report. 

Thanks.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
9 years ago

Hi SachinC,

Thanks for your detailed information. Please mark your solution as answer, so other people will find solution easily.

Best Regards,
Angelia