card to table

[jakabtamas]

Dear Community,

How can I copy the actual value of a card and the actual date to a table when refresh data from excel?

I want to save the changes of the card!

Thanks and regards

Tamas

[V-lianl-msft]

Hi @jakabtamas ,

Basically, Power BI is an Interactive Data Visualization BI Tool. It is used to display data and store data.

As you want to keep the history. I'm afraid your requirement cannot be achieved directly.

You could try this alternatives:https://community.powerbi.com/t5/Desktop/Save-old-and-append-updated-data-into-an-additional-table/m... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jakabtamas , not very clear. But something very similar to https://www.enhansoft.com/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

[jakabtamas]

Hi,

For example the card now is 10. After the next refresh it will be 12, and after the another refresh it will be 11.

I need a table like this:

date    value

22.02.21   10

23.02.21   12

24.02.21   11

How can I do it?

t