Forum Discussion

SvenJacobs's avatar
SvenJacobs
Frequent Visitor
5 years ago

AND OR in Filter

I have a small issue and do not seem to get the DAX code correct.   Need to know the amount of flats occupied. For this i do a count of contractid and i want to match 2 dates Date 1 = DatumInHu...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

SvenJacobs 

Please try:

FlatsBezetPerDatum =
VAR __startdate =
    FIRSTDATE ( DateTable[Date] )
VAR __enddate =
    LASTDATE ( DateTable[Date] )
RETURN
    CALCULATE (
        COUNT ( 'Bewoners_Contracten (Sharepoint)'[ContractId] ),
        FILTER (
            'Bewoners_Contracten (Sharepoint)',
            'Bewoners_Contracten (Sharepoint)'[DatumInHuizing] >= __startdate
                && ( 'Bewoners_Contracten (Sharepoint)'[DatumuithuizingZonderNull] <= __enddate )
        ),
        'Bewoners_Contracten (Sharepoint)'[DatumInHuizing] <> BLANK()
    )
SvenJacobs's avatar
SvenJacobs
Frequent Visitor
5 years ago

The 2 DAX codes seem to work only I guess my thinking is not correct..... Why because if I have 100 flats i can not. Need to figure out how your HR thing worked. Because I want to know on a specific date in time the amount of flats that wher rented out.