Forum Discussion

zaheerahmed's avatar
zaheerahmed
New Member
7 years ago
Solved

Monthly Updated Report Data in Excel

Hi   I have an excel file where the data is hosted locally on my computer. My issue is that each month I get a new excel workbook with the "new month's data" but I don't want to go through the clea...
Need Help
Tips and Tricks
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi zaheerahmed ,

    For your requirement, I think you could try to use Query Parameter in Power BI.

    Please refer the suggestion of PattemManohar in this similar thread which should be helpful. You could get the monthly data firstly and then append the queries so that you could keep the previous data and the latest data in one table to show the comparison.

    In addition, this solution may be a choice either.

    Best Regards,

    Cherry

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi zaheerahmed ,

For your requirement, I think you could try to use Query Parameter in Power BI.

Please refer the suggestion of PattemManohar in this similar thread which should be helpful. You could get the monthly data firstly and then append the queries so that you could keep the previous data and the latest data in one table to show the comparison.

In addition, this solution may be a choice either.

Best Regards,

Cherry