CALENDAR and CALENDARAUTO Function in DAX

Learn the nitty gritties of CALENDAR and CALENDARAUTO functions in DAX.
- - - - My Courses - - - -
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
- - - - Blog - - - -
www.goodly.co.in/blog

[@nikitamudgekar9669]

Thank you. Great explanation.🙂

[@santoshkamala2750]

Very nicely explained. However, I have a question:
I have two date columns in my table (Start Date and End Date).
I want to give a calendar picker to my user in visualization page. Based on the date selected by my user, I want to calculate two columns:
First column: "How many days completed?"
Formula: Selected Date - Start Date + 1
Second column: "How many days to GO" ?
Formula: End Date - Selected Date + 1
Requirement 1:
How can I create a calendar picker in visualization page ? Can SLICER will work as a specific date picker ?
Requirement 2:
Based on the date selected in first step, which DAX function will use to calculate the required columns. Note: DAX will be written in such a way which can understand what date was chosen by user
Please help !!! If you have already any CZcams video link, please share.

[@tanweerabbasabbas649]

Thks jeee.❤️

[@FullMoonHatch]

thanks, love your videos

[@GoodlyChandeep]

Glad you love them!

[@shabnamattar5632]

when we have to create measures & when we crete calculated column or table

[@vishaljhaveri7565]

Nice video, Sir. Thank you, Sir.

[@GoodlyChandeep]

Glad you like it 😊

[@priya1231108]

If I am having 2 dates sales date and purchasing date .both date start and end is different.so calendar auto fuction fetch which date exactly here in this scenario.

[@fog2640]

finished watching

[@kummithavenkatareddy2302]

I want to learn DAX and M language and useful cases. When you will start classes for that.

[@anisshaikh5325]

Superb 👍

[@GoodlyChandeep]

Thank you! Cheers!

[@AshokKumar-sh7zi]

Thank you

[@GoodlyChandeep]

😊💚

[@zaravind4293]

How to use calendarauto function with specific table

[@NerdIntern]

what if my table has multiple date column

[@williamarthur4801]

One thing I would like to know, how did you zoom in on pbi formula bar, I can do this in pq
using ctrl shift + or - , but it doesn't seem to work here and it would really help as at the moment I do keep a magnifying glass on the desk. 😣

[@GoodlyChandeep]

Zoom on formula bar Ctrl +
I also created a video on a few interesting shortcuts here czcams.com/video/LggOIgR2tn8/video.html

[@williamarthur4801]

@@GoodlyChandeep Thank you so much.

[@arikaibedorisnkeiruka]

Pls I’m still getting 1899 date even after following this steps. Pls help

[@pawansharma-wo3xh]

Thanks.
But i am still confuse about the exact use of calender table.
Can you please make a video on why calender table is important in power BI

[@GoodlyChandeep]

Sure!

[@PK-iu9nc]

Hi,
I have a doubt that these functions works only when our dataset should consists of atleast one date column ? or works if there are no date columns as well. Kindly revert back

[@GoodlyChandeep]

You're right the table should have at-least one date column.

[@PK-iu9nc]

1. If the date column starts from 01-01 of the year and ends in 31-12 of the same year, Then how it provides the date ranges.
2. When I provide the input, It gives the date ranges beyond the year present in the dataset.
Kindly clarify....

[@kummithavenkatareddy2302]

Y we need a date table. Do we need a date table even though we are not going to do any time intelligence DAX on power BI.

[@GoodlyChandeep]

Yes! Ideally all date dimensions (year, month, qtr) should be pulled from the Date table!