topic Re: DATEDIFF and IF in DAX Commands and Tips

DATEDIFF and IF

Seth4040 — Mon, 24 Jun 2024 15:50:17 GMT

I am trying to add 7 days to the "Task Completion Date" if the "Task Status" is = CONCOMP which gives me the "GF Job Card Due Date" column. Thank you.

GF Job Card Due Date = IF(DATEDIFF(

Re: DATEDIFF and IF

mark_endicott — Mon, 24 Jun 2024 16:06:06 GMT

Seth4040 - Try this as a calculated column:

IF( Table[Task Status] = "CONCOMP", SUMX( Table, Table[Task Completion Date] + 7), Table[Task Completion Date])

If you only need the values where 7 days have been added then this will work:

SUMX( FILTER(Table, Table[Task Status] = "CONCOMP"), Table[Task Completion Date] + 7)

The above can also be used in a measure.

If either of these work, please accept this as the solution.

Re: DATEDIFF and IF

Seth4040 — Mon, 24 Jun 2024 16:30:35 GMT

This kind of worked but showing the date as 12/31/9999 for some reason. I did change the first one just a little and got what I am showing. The second one had the same outcome exect dates in all the fields even when not = to CONCOMP and again the dates were 12/31/9999

Re: DATEDIFF and IF

Seth4040 — Mon, 24 Jun 2024 16:38:52 GMT

Ok got it fixed and attached what I got it to. Thanks for your help.