Taking weekly snapshots of tables

[BarryM]

Thanks in advance for your assistance.

I have a report that will be updated each week on the same day(Wednesday). In that report I have two tables os sums of values by FY where I need to be able to determine if any of the figures have changed since the previous report update(the previous week). Below are images of the two tables I need to track. If a change to any of the figures has occurred since the report was last updated I need to conditionally format the text in a different colour. I've looked at a number of possible solutions butwas unable to adapt them to my particular needs

[AnthonyGenovese]

Hey @BarryM 

I don't think this is a problem for Power BI. If this was my team, this is more of a data engineering (and likely a core data warehouse data model) problem to solve. Like you said in the title, you need to take weekly snapshots of data.  If you wanted to, you could take the dax formula from your visual, then write a process that runs a dax query, and then saves that data back in a SQL table somewhere, (likely with a intermediate step of saving it as a csv). You then could load that back into your model and create measures that takes the difference between current data and this saved off data.

But honestly, that is just extra steps to me. I would personally tell my data engineers to start snapshotting the needed data, build some historical/temporal tables and build out our base data model taht way, and just import what you need into PowerBI in one step. 

If this post was helpful, please kudos or accept the answer as a solution.
~ Anthony Genovese
Need more PBI help? PM me for affordable, dedicated training or consultant recomendations!