Forum Discussion

Tojo1's avatar
Tojo1
New Member
3 years ago
Solved

How to understand CROSSFILTER

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

1 Reply

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