Forum Discussion

SSWADOOD's avatar
SSWADOOD
Helper I
5 years ago
Solved

DAX FOR PLSQL

Hello,    i am trying to convert  into dax DATE_BETWEEN = var SDATES= MIN('START_DATE'[START_DATE]) var EDATES= MAX('end_DATE'[end_DATE])   return IF ( (DATESBETWEEN(DETAILS...
  • amitchandak's avatar
    amitchandak
    5 years ago

    SSWADOOD , I think you need something like this

     

    measure 2 =
    VAR minDate = MINX( allselected('Calendar') , 'Calendar'[Date] )
    VAR maxDate = MAXX(allselected('Calendar') , 'Calendar'[Date] )
    RETURN

    calculate(countrows(Table), filter(Table, (Table[term start Date] <=_max && Table[term start Date] >=_min) || (Table[term end Date] <=_max && Table[term end Date] >=_min)))

amitchandak's avatar
amitchandak
Super User
5 years ago

SSWADOOD , I think you need something like this

 

measure 2 =
VAR minDate = MINX( allselected('Calendar') , 'Calendar'[Date] )
VAR maxDate = MAXX(allselected('Calendar') , 'Calendar'[Date] )
RETURN

calculate(countrows(Table), filter(Table, (Table[term start Date] <=_max && Table[term start Date] >=_min) || (Table[term end Date] <=_max && Table[term end Date] >=_min)))