Showing previous period values

[stribor45]

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.

[Fowmy]

@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

[stribor45]

The 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 · Accepted solution]

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.

[stribor45]

Do you mean to add another column between current and previous?

[lbendlin]

For a generic solution on "previous values" you can also consider using the OFFSET function ( with REL -1)