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
tfeldt2020
Frequent Visitor

Current Period vs Prior Period Status Change

Hi,

 

I have a column "Comp/Not Comp" that I am filtering on for a comparison between two periods of time (Current Period/Prior Period). If I select the Current Period as 2019 and the row item is "Comp" in 2019, but "Not Comp" in 2018, I don't want the filter to apply. I only want to filter out the items if the "Not Comp" applies in the Current Period. I don't want the "Not Comp" status of the Prior Period to affect the filter.

 

Thanks!

1 REPLY 1
Icey
Community Support
Community Support

Hi @tfeldt2020 ,

 

What is your data structure and model? How did you filter? Please share us more details, such as some sample data.

 

 

Best Regards,

Icey

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.