Forum Discussion
Data Archiving
Hi jh123456 ,
You can refer to this blog to calculate YTD, MTD...https://www.mssqltips.com/sqlservertip/4841/calculating-mtd-qtd-ytd-running-and-cumulative-total-in-power-bi/
You can use data flow to save historical data:https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi jh123456 ,
You can refer to this blog to calculate YTD, MTD...https://www.mssqltips.com/sqlservertip/4841/calculating-mtd-qtd-ytd-running-and-cumulative-total-in-power-bi/
You can use data flow to save historical data:https://visualbi.com/blogs/microsoft/powerbi/historical-data-preservation-using-power-bi-dataflow/
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.