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

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))

Forum Discussion

DAX - If statement with datediff based on most recent date

Related content

DATEDIFF DAX

DateDiff with IF statement

OR Statement ?

DATEDIFF with IF statement?

Most Recent Transaction