Store calculated column

Hi @nitishpala - can you explain a little further what you want you visual to look like? If you are trying to build columns that represent this month, last month, etc, you can try the approach in this article: Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

If your values from a given month (lets say Mar 2023) change over time and you are trying to snapshot what Mar 2023 looked like over time, you will need to do this in the ETL stage as @Sanjeeb2022 mentioned. Should take a snapshot of the table every month and append/union it every month with a new column indicating which month the snapshot is from. Then you can track changes between the months.

1 Like