Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

TRICKY max date - Calculated column measure

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 h...
Need Help
  • amitchandak's avatar
    amitchandak
    3 years ago

    Anonymous , A new column like

     

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

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
3 years ago

Anonymous - You have the same issue as your last post; the variant data type: