Power Query dynamic filter based on Todays date

Power Query Data Setup
#1

Hello,
I would like to create a dynamic filter in Power Query in order for Table (as referring in the attached pbix) to be filtered on the dates that belong to the current Quarter in Calendar column from the date table as of today’s date.

In my example I would like to have in Table only the 3 following dates: March 15th, March12th and March 10th.

Any help would be appreciated.

Thank you,
17032023.pbix (117.6 KB)

#2

Hi @Cedric,

The M standard Library contains a number of ‘relative date’ functions that are all evaluated against the current date and time “on the system”. Note that for queries refreshed in the Power BI Service this means UTC. When in doubt you can always request the current timezone with the dynamic TimeZone.Current value.

Give this a go.

Date.IsInCurrentQuarter( [Date] )

.
Read more here

I hope this is helpful

#3

Hello @Cedric,

Did the responses above help solve your query?

If not, can you let us know where you’re stuck and what additional assistance you need?

If it did, please mark the answer as the SOLUTION by clicking the three dots beside Reply and then tick the check box beside SOLUTION

Thank you