How "save" KPI day after day

[projectPACA]

Hi !

I created a dashboard with 3 data tables (.xlsx). Everyday I replace the tables by the 3 new tables of the day. I count the rows of tables and this is my KPI (how much case of water meter in default this day, for exemple).

BUT (yes... there is a problem...)

I can't build a histogram (for exemple) with the data of today and yesterday and the day before because I refresh the data of the day only.

For yet, I write everyday manualy in another .xlsx the key indicators of the day. But I'm looking for collect the result day after day to build curves. (to compare today and the past)

Where I need to search ? what I need to do ?

(sorry for my bad english)

Thank you so much

[v-frfei-msft · Accepted solution]

Hi @projectPACA,

You can combine the new tables and the previous tables together and filter the latest record by slicer or something else. Then you can compare the data of today and past. 

Also sample data would help tremendously. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Regards,

Frank

[v-frfei-msft]

Hi @projectPACA,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,

Frank

[projectPACA]

Yes thank you so much !

[v-frfei-msft]

Hi @projectPACA,

Kindly mark my answer as solution to close the case please.

Regards,

Frank