Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
stribor45
Post Prodigy
Post Prodigy

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 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.

 

stribor45_0-1705169639554.png

 

1 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.

View solution in original post

5 REPLIES 5
Fowmy
Super User
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





Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

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?

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.

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

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors