Power Query (M) script to create a Date table in Power BI!

Thank you Mitchell.

What if the Month starts in a d/f month (e.g. fiscal year starts in Oct.)?

specifically how would I add years to the formula bar?

Thanks ! :)

Great Video

Hi Mitchell... Amazing video..🤟🤟
Could you pls make a tutorial video where if user select a date like 9/10/21...then user can see the sales of 9/10/20, 9/10/19, 9/10/18 so far so on.....same can be modified to monthly and quarterly date difference as well...

Can we use CalenderAuto() function to create a date table? As it will automatically create dates as per the data available.

amazing video Mitchell. I have a query. Which is BETTER way to create Date table if internal IT team has not created?
Using M code or with DAX? What about performance? What will you recommend?

Good one..well explained