Forum Discussion

stribor45's avatar
stribor45
Post Prodigy
2 years ago
Solved

Showing 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...
Need Help
Show and Tell
  • lbendlin's avatar
    lbendlin
    2 years ago

    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's avatar
stribor45
Post Prodigy
2 years ago

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's avatar
lbendlin
Super User
2 years ago

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's avatar
    stribor45
    Post Prodigy
    2 years ago

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