cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Calendar Dax

Hi,

 

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

Thanks in advance.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Calendar Dax

1111333.JPGAFTER 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)

5 REPLIES 5

Re: Calendar Dax

what do you exactly need?

 

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

 

 

Re: Calendar Dax

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

Re: Calendar Dax

1111333.JPGAFTER 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)

Re: Calendar Dax

THANKS A LOT CHRISTIANFCBMX. IT WORKED PERFECTLY.!

Highlighted

Re: Calendar Dax

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