Forum Discussion
Post ProdigyShowing previous period values
The best visual for that will not use the term "previous period" but will spell out the scope ( for example January 2023) so there's no ambiguity.
Super Userstribor45
Provide clear explanation and some sample data and the expected results. When you say Previous, is it previous month/QTR/Year/Day ?
If you have a dates or calendar tabble in your model, you can use the time intelligence function in DAX to get the desiresed results. Time intelligence functions (DAX) - DAX | Microsoft Learn
- lbendlin
For a generic solution on "previous values" you can also consider using the OFFSET function ( with REL -1)
stribor45The report has two slicers. Slicer #1 is months and slicer # 2 is years.
If user selects 2024 and January it will show the following data
Current - this would be January 2024 data
Prev - this would be the same data from last year (January 2023)
Change - variance between the two
If the user selects 2023 it will show following
Current - Jan. Feb, March etc for 2023
Prev - Jan, Feb, March etc for 2022
Change - variance between the two
"Prev" uses SAMEPERIODLASTYEAR function.
My quesrtions is more about is there a different way to present this data. If you look at my image above without me telling you what is woud you know what it is showing?