Forum Discussion

lexalexa's avatar
lexalexa
New Member
8 years ago
Solved

sum if

Hi,   I have two tables. One has list of unique dates. The other one has bookings each with a pick up date against it. In my first table I am trying to count how many bookings there are in the othe...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    lexalexa,

     

    You may refer to measure below.

    Measure =
VAR d =
    SELECTEDVALUE ( Table1[Date] )
RETURN
    COUNTROWS ( FILTER ( Table2, Table2[Pick up date] >= d ) )
Lind25's avatar
Lind25
Resolver I
8 years ago

This should do the trick.

 

Upcoming bookings = CALCULATE(
    COUNTROWS(Table2),
    All(Table1),
    DATESBETWEEN(Table2[Pick up date],FIRSTDATE(Table1[Date]),BLANK())
    )

 

This assumes you have related Table1 and Table2. Then add the measure and the date column from Table1 to a table visualisation.