Compare daily data using excel data

[gsmjlc]

Hi,

I am a complete newnie regarding Power BI so your help (and patience) is very much appreciated.

I have been tasked with creating a KPI dashboard and have played with this software and think it is great.  I can create roughly what I need but it is on a single date basis.  However the issue I now face is that my boss wants to track daily changes in events, sales, etc.

We are quite backwards in the data I can export and can only export excel files each day.  

Is there a way that I can build a report that will show these changes using only excel files?  I don't have any other kind of programming skills (Access/VBA/etc for example) so you are really dealing with a luddite here!

Thanks,

Alan

[Anonymous]

Hi @gsmjlc,

According to your description, you want compare multiple excel file which has the same structure, right?

You can try to store these files to folder and use power bi get data from this folder.

For detail information about use power query to compare two table, you can refer to below blog:

Compare two tables or reports using Power Query

In addition, you can also use dax function to compare tables.

EXCEPT Function (DAX)

INTERSECT Function (DAX)

Regards,

Xiaoxin Sheng

[gsmjlc]

Hi @Anonymous,

Thanks for the reply.

The columns will not alter but the rows will as more customers are added.  I can see how this would work on the occasional report to display the changes.  However I am looking to do this daily and so the combined excel sheet would become larger and larger after a month or two (I think).

Is there a way that if I drop the raw data for each day into a workbook, I can compare between each and report either numerical or % changes?

I appreciate that I may have got this completely wrong so your advice is really appreciated.

Thanks,

Alan

[Anonymous · Accepted solution]

Hi @gsmjlc,

In my opinion, I think you can add a column which used to mark the added date, then use this column to analysis the increase percent.

Regards,

Xiaoxin Sheng