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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
MirandaJ
Regular Visitor

Pulling data from last 6 months

Hi, I've created a query that will retrieve data from SharePoint and then will create a dashboard with that data. However, this dashboard eventually will be huge and I only want to retrieve the last 6 months of data, including today's date, starting from a column called Admission Date.

 

For example, a row on any given file on that SharePoint has X Admission Date, so if that date is beyond 6 months from today, that data will not be pulled into my dashboard. Hence, everything with an Admission Date within 6 months from today, will be pulled.

 

The caveat here is that TODAY's date will always be dynamic.

 

Sorry I cannot provide my dashboard since it's confidential data

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

vicky__0-1709070536475.png

If you go into PowerQuery, there's an option to just load data that is from the last n months.

View solution in original post

1 REPLY 1
vicky_
Super User
Super User

vicky__0-1709070536475.png

If you go into PowerQuery, there's an option to just load data that is from the last n months.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors