persist measure

[adciudad]

How can I persist measures at a certain date? That is, in my data model, a measure has a value today, but tomorrow will have another. What I want is to store that value for each day and then not be affected.

[v-shex-msft]

Hi @adciudad,

I'd like to suggest you use today function to get current date based on system datetime.

TODAY Function (DAX)

Regards,

Xiaoxin Sheng

[adciudad]

No.

The issue is that my measurements generate certain values ​​in a day, but if I re-execute the measurements the next day, the values ​​will be different. What I want to know is if it is possible to store the value of the measurements during each day and leave it saved in a separate table.

[v-shex-msft]

HI @adciudad,

Nope, current power bi not contains any writeback and cache data features. You can to consider to use third party applications to achieve this and use power bi to get data from stored data.

Regards,

Xiaoxin Sheng

[adciudad]

for example?

[v-shex-msft]

HI @adciudad,

You can consider to use python or other programming language to get data from datasource and export them as excel file to a specific folder.

After these steps, you can use power bi to get data from that folder and create visuals based on these data.

Regards,

Xiaoxin Sheng