Forum Discussion
Post ProdigyShowing previous period values
I am trying to show the current and previous revenues based on user time selection in the slicer. I am wondering if you can give me feedback on this table because as I have shown it to a couple of my colleagues I needed to explain to them what it shows. any ideas on improvement on this and if you have your solution example you can share.
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.
5 Replies
- Fowmy
Super User
stribor45
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?
- lbendlin
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.
