Variable

[abTech]

How to count a specific value using a variable:

to count the flight if arrival_date is less that depart date

i used this expression  count({<arrival_date < departure_date }> flights)

[HirisH_V7]

Count({$< arrival_date = {"<$(=depart date)"}>} Flights)

[marcus_sommer]

In many scenarios it would be beneficial to do the essential work within the data-model - with something like:

Date1 - Date2 as DateOffset
class(Date1 - Date2, 3) as DateOffsetCluster,
sign(Date1 - Date2) as DateOffsetDirection

which could be used as dimensions and/or selections and/or conditions.

[TauseefKhan]

Hi @abTech,

LOAD *,
If(arrival_date < departure_date, 1, 0) as FlightFlag
FROM [YourDataSource];

And then use this flag in your expression:

count({<FlightFlag={1}>} flights)