Peildatum filter signalering bijz verlof = MINX('Contract Custom Fields', SWITCH(TRUE(),AND ('Contract Custom Fields'[AGBV einddatum (PI0153)]<=MAX('Reference date filters'[Date]),'Contract Custom Fields'[AGBV einddatum (PI0153)] >= MIN('Reference date filters'[Date])),1, AND ('Contract Custom Fields'[WBOV einddatum (PI0175)]<=MAX('Reference date filters'[Date]),'Contract Custom Fields'[WBOV einddatum (PI0175)]>= MIN('Reference date filters'[Date])),1, AND ('Contract Custom Fields'[CBOV einddatum (PI0002)]<=MAX('Reference date filters'[Date]),'Contract Custom Fields'[CBOV einddatum (PI0002)]>= MIN('Reference date filters'[Date])),1, AND ('Contract Custom Fields'[OOV einddatum (PI0180)]<=MAX('Reference date filters'[Date]),'Contract Custom Fields'[OOV einddatum (PI0180)]>= MIN('Reference date filters'[Date])),1, AND ('Contract Custom Fields'[Einddatum OV (E00232)]<=MAX('Reference date filters'[Date]),'Contract Custom Fields'[Einddatum OV (E00232)]>= MIN('Reference date filters'[Date])),1, AND ('Contract Custom Fields'[Eind generatiepact (E00084)]<=MAX('Reference date filters'[Date]),'Contract Custom Fields'[Eind generatiepact (E00084)>= MIN('Reference date filters'[Date])),0)
... View more