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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
castigs10014
Regular Visitor

Same Store Sales (only if a store was not opened or closed within the date filter range)

Hello, 

 

Having trouble understanding how to include/exclude total sales within a date filter (from same period last year and current year) if the store was either opened within the date filter dates or closed within the date filter dates both this year and same period last year.  

 

For example, my date filter is set from 1/1/17..8/31/17.  I want to exclude stores that were closed or opened on 6/1/2016 and stores that were opened on 5/1/17.  Basically, only stores that were open throughout the entire date filter.  I want this to be able to recalculate when the date filter is changed by the end user.

 

Any ideas would be appreciated.

Thanks!

1 REPLY 1
stretcharm
Memorable Member
Memorable Member

 

This post seems to have a similar requirement and a solution.

https://community.powerbi.com/t5/Desktop/Filtering-within-a-date-range/td-p/227767

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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