Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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
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.
in the Slicer i have the field YearQT, but the relationship betwwen the tables is by the field Date.
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.
Go to Solution.
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
View solution in original post
Guaoo it is just i Needed, thank you!!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.