Variable Table

[Anonymous]

I have a measure that changes every day, but I need to create a table that records this measure​​, for example:

Yesterday I had a number "10" in a measure,

But today the number "10" is lost and I start to have a number "20" in a measure. And every day it changes.

I need a table to record all these variable numbers, for example: In this case in my Variable Table will have:

Date	Number
Yesterday	10
Today	20
Tomorrow	XXX

And the table keeps accumulating the variable values for 30 days, it is possible?

Tks a lot!

[Anonymous · Accepted solution]

Hi @Anonymous 

Measures are dynamic, while calculated tables are static, and we cannot use calculated tables to store the daily dynamics of measures.

You can try to extract the data of the measure every day, then store it into a excel. You can use power automate to implement it, you can refer to the following link.

Solved: export data from power bi visuals to excel automat... - Microsoft Power BI Community

Best Regards!

Yolo Zhu

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