Forum Discussion

SachinC's avatar
SachinC
Icon for Helper V rankHelper 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
Icon for Helper V rankHelper V
9 years ago

Yes, thanks for that. I figured this out eventually myself.

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

Hi SachinC,

I am very glad to hear that you have resolve your issue, could you please share your solution which will help more people?

Best Regards,
Angelia

  • SachinC's avatar
    SachinC
    Icon for Helper V rankHelper 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
      Icon for Microsoft Employee rankMicrosoft 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