Forum Discussion

cuseman03's avatar
cuseman03
Icon for Helper I rankHelper I
3 years ago
Solved

DAX - If statement with datediff based on most recent date

Hi all,   so I am pretty close to what I need to do but just stuck on this last part.  Ok, so I have two columns from SQL, one is a 'start date' and one is an 'end date'.  Format is datetime.  I us...
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    Hi,
    my solution:

     

     

    DATEDIFF =
    VAR     _varstart = maxx(Tabelle11,Tabelle11[Start])
    VAR _varend = maxx(Tabelle11,Tabelle11[End])
    VAR _varmaxstart = maxx(ALLSELECTED(Tabelle11),Tabelle11[Start])
    RETURN
    IF(_varmaxstart=_varstart,DATEDIFF(_varstart,TODAY(),DAY),DATEDIFF(_varstart,_varend,DAY))
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

Hi,
my solution:

 

 

DATEDIFF =
VAR _varstart = maxx(Tabelle11,Tabelle11[Start])
VAR _varend = maxx(Tabelle11,Tabelle11[End])
VAR _varmaxstart = maxx(ALLSELECTED(Tabelle11),Tabelle11[Start])
RETURN
IF(_varmaxstart=_varstart,DATEDIFF(_varstart,TODAY(),DAY),DATEDIFF(_varstart,_varend,DAY))