Max Date Calculated column Measure not work to give MAX Date

[Anonymous]

Hi Experts

See expected result in the table below with light blue header. Need a cacalated column measure to give the max ACTDate if all the Child TaskID and WorkORder ID's have a date. If they have no ACTDate as shown in the first image then return back no max date..

The following measure which was done by a Experts on this site give the same same dates as shown in the second image with Blue Headers. SHOULD BE THE MAX DATE as shown above 12.04.2022

Measure = if([POC] ="Parent" , blank(), maxx(filter(Table, [TAsk id] =earlier([Task id]) && [Workitem id] =earlier([Workitem id]) ), [Act Date])

[grantsamborn · Accepted solution]

Hi @Anonymous 

Your measure appears to be a calculated column.  If you make that change, it appears to match your expected results.

Let me know if this helps.

[Anonymous]

Hi Grant - what change?

[grantsamborn]

You have to create a calculated column instead of a measure.

[Anonymous]

i need a calculated column,,,,the calcaulted column measure is not correct. thanks

[grantsamborn]

I'm not sure what you mean by "calculated Column measure".

A DAX calculation can result in a Calculated Table, Calculated Column OR a Measure.

Take a look at my pbix.

CalcColumn_problem.pbix

[Anonymous]

Calculated Column