Calendar Dax

[colourfullife]

Hi,

I am trying to make a master calendar which include all dates that are in different matrix.

Thanks in advance.

[christianfcbmx]

what do you exactly need?

2 ways... use the function "calendarauto()" in the section "add a table"

[colourfullife]

I have 5-6 coloums of dates in 2 tables.

Want to make a 'MASTER CALENDAR' which start earliest date in datasource to lastest date.

Manually made calendar but want it to be working automatic. looking for a dax which can create a caleadar start ealiest to lates based on datasource

[christianfcbmx · Accepted solution]

AFTER THAT THE CALENDAR AUTO FUNCTION WILL CREATE A CALENDAR TAKING THE ERALIEST AND THE OLDEST DATE IN YOUR MODEL (DONT FORGET TO MAKE THE RELATIONSHIPS WITH ALL YOUR TABLES INTO THE MASTER CALENDAR)

[colourfullife]

THANKS A LOT CHRISTIANFCBMX. IT WORKED PERFECTLY.!

[christianfcbmx]

yourwelcom @colourfullife , dont forget to accept the answer as a solution!!! see ya later!