[Power BI] Creating a Calendar Table in the Power Query Editor

Thanks for sharing! super helpful

Your end date is fixed; how do we get the end date to grow? What if I wanted the end date to be 2 weeks after current date?

Thank you very much for this great video..

Very helpful thanks for sharing I always learn power bi from @pragmatic works❤❤

I like your way of teaching!
Thank you for that

You’re handsome:)

you are the best

Thank you very much, this video really get me into build a fine calendar. easy and fast. Tnx again

Good one and best explanantion and clearly easily understand the subject .Thanks a lot

Hello 👋 maybe you could help me about other topic but related to date as well.

Problem : For my End date, I want to get the end of the month (date format) of my previous month as of today end of month local now values. Would this be possible?

Example;
Today EOM: Feb 28, 2022

Goal
Prev EOM: Jan 31, 2022

Hope you can help me resolve this one. Many thanks 😊

I read this line in the dax manual by Microsoft and I don't get it. they practically mention it for every dax function. "This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules."

there is no month 14.....

Great tutorial! Thanks for sharing.

Great one! Thanks. How can it be integrated with working days and scheduled holidays if, for example, I want to count only working days between dates? Thanks in advance.

Thanks for sharing! 👍

Can you show how to add column with weeknumbering in the same formatting style as in Oracle with TO_CHAR('IW') (according to ISO-standard).

Thanks. What are differences between creating date table using M code and DAX?