Forum Discussion
How to calculate changes in data cubes on a weekly bases
Hello, I have created two similar tables (same datasource) from which I calculate on weekly bases what are the changes from week to week. Therefor I use AFO' s as source. I have to update this ma...
v-yanjiang-msft
Community Support
Community SupportHi Anonymous ,
According to your description, you can use the function automatic page refresh in Power BI Desktop which is only available for DirectQuery sources and some LiveConnect scenarios.
Automatic page refresh in Power BI enables your active report page to query for new data, at a predefined cadence like below.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Community Support Team_yanjiang
Sorry for my late reply but I was on a short vacation.
I managed to built the report from DirectQuery and used the Auto Page refresh every 7 days. But I think it will overwrite the old data and I want to calculate the differences between last week and current week