Solved: update today date M Query

Rami_Aziz · ‎01-08-2023

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 · ‎01-08-2023

Hi @Rami_Aziz ,

You could refer below article:-

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

View solution in original post

Samarth_18 · ‎01-08-2023

Hi @Rami_Aziz ,

You could refer below article:-

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

Best Regards,
Samarth

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin

update today date M Query

Helpful resources

Fabric Community Update - November 2024

Be one of the first to start using Fabric Databases

Join us at the Microsoft Fabric Community Conference

Power BI Monthly Update - November 2024

Be one of the first to start using Fabric Databases.