Calendar with data from 2 tabels

[Bjarne-KA]

I would like to make a calendar which retrieve the start and end date from two tables where to take the minimum and maximum date.

[MFelix · Accepted solution]

Hi @Bjarne-KA,

Try something like this:

Calendar date =
CALENDAR (
    IF (
        MIN ( Table1[date] ) < MIN ( Table2[Date] );
        MIN ( Table1[date] );
        MIN ( Table2[Date] )
    );
    IF (
        MAX ( Table1[date] ) > MAX ( Table2[Date] );
        MAX ( Table1[date] );
        MAX ( Table2[Date] )
    )
)

Regards,

MFelix

[Bjarne-KA]

Thank you very much, now it works

/Bjarne