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
gomezc73
Helper IV
Helper IV

Issue to filter data by last quarter

Hi,

 

  I need help to select all records of a file from the first date date available in the data to a Quarter selected in a Slicer.

 

  That is, as if it were a range of dates, but I can only select the maximum date, the minimum date is the first available in the table

 

  Let me explain, I have the table 'AR Consolidated' with all shipments. In this file there is a Field called 'return date'.

 

  I've create a calendar table, with all days using this command

  AR Calendar = calendar(Min('AR Consolidated'[Return Date]), TODAY())
 

diagram.JPG

 

 I am selecting the Year/Quarter in a slicer, than i need filter all records in  table 'AR Consolidated, from the first date available thru the year/quarter selected.

 

 By example, i have records from the Jan 2020, if i select in the slicer (2023-Q1), then i need show in my data all records from Jan 2020 to March 2023.

 

gomezc73_0-1685733504308.png

 

in the Slicer i have the field YearQT, but the relationship betwwen the tables is by the field Date.

gomezc73_1-1685733901476.png

 

 I need select in the range on records select, the Top 10, and other calculations but only consider records with return date less than or equal the quarter selected.

 

I really appreciate your help.

1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @gomezc73 
Please refer linked tutorial, if I understand you correctly it should help:
https://www.youtube.com/watch?v=YWfLrezEc84

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @gomezc73 
Please refer linked tutorial, if I understand you correctly it should help:
https://www.youtube.com/watch?v=YWfLrezEc84

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Guaoo it is just i Needed, thank you!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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