In our models, the best way to deals with dates and DAX intelligence functions is to use a Calendar Table (Dimension). Good news, this table can be created in 2 clicks with Power Query (Transform Data) in Power BI!
Go transform data and right click on Queries to create a new Blank Query
Copy / Paste this code
Choose a start date and an EndDate, click Invoke
That’s it! You have a beautiful calendar table.
Credit: I found this code on internet many years ago and used it in the LazyDAX file. I think I changed it, but I can’t redirect and credit the one who created it. I think it can help you a lot, that’s why I’m sharing it with you :)