Forum Discussion
Rami_Aziz
3 years agoHelper I
update today date M Query
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
Hi Rami_Aziz ,
You could refer below article:-
https://www.mssqltips.com/sqlservertip/6756/power-bi-calendar-table/
1 Reply
- Samarth_18Community Champion
Hi Rami_Aziz ,
You could refer below article:-
https://www.mssqltips.com/sqlservertip/6756/power-bi-calendar-table/