update today date M Query

[Rami_Aziz]

Good Day Guys.

I create the following M query below as a calendar but i need it to update to today date everyday,

so the start date will be 1-Aug-2022 and end date is today and it will be updated next date:

= Query1(#date(2022, 8, 1),#date(2023, 8, 1))

Thanks in advance

[Samarth_18 · Accepted solution]

Hi @Rami_Aziz ,

You could refer below article:-

https://www.mssqltips.com/sqlservertip/6756/power-bi-calendar-table/