How to understand CROSSFILTER

[Tojo1]

Hello

I have never worked with Power BI earlier.

I have this Dax code below where HistoryFact_Booking is the many side and Dim_Calendar_ArrivalDate is the one side.

Can somebody help me to understand this,

CALCULATE(max(Dim_Calendar_ArrivalDate[Date]),
    CROSSFILTER(HistoryFact_Booking[Dim_CalendarArrivalDate_SK],
    Dim_Calendar_ArrivalDate[Dim_Calendar_SK], None))

Many Thanks in advance

[amitchandak · Accepted solution]

@Tojo1 , this will not consider joining with the history table while giving MAX date