Forum Discussion

JoeHazelton's avatar
JoeHazelton
Frequent Visitor
4 years ago
Solved

Date status column

Dear Community, I am looking to create a column which indicates the status of each task which covers all eventualites. I am using four date columns, Start Date, Finish Date, Actual Start & Actual Fi...
  • DimaMD's avatar
    DimaMD
    4 years ago

    JoeHazelton I tried to simulate the example data, look maybe it will lead you to the right idea in solving your problem

    measure = 
SWITCH( 
    TRUE(),
    [Start Date] > TODAY(), "Planned",
    AND([Start Date], [Finish Date]) && AND([Actual Start], [Actual Finish]) <> BLANK(), "Complete",
    AND([Start Date] <= TODAY(), [Actual Start] = BLANK()),  "Late Starting", 
    "Late Finishing"
      )


DimaMD's avatar
DimaMD
Icon for Solution Sage rankSolution Sage
4 years ago

JoeHazelton I tried to simulate the example data, look maybe it will lead you to the right idea in solving your problem

measure = 
SWITCH( 
    TRUE(),
    [Start Date] > TODAY(), "Planned",
    AND([Start Date], [Finish Date]) && AND([Actual Start], [Actual Finish]) <> BLANK(), "Complete",
    AND([Start Date] <= TODAY(), [Actual Start] = BLANK()),  "Late Starting", 
    "Late Finishing"
      )


JoeHazelton's avatar
JoeHazelton
Frequent Visitor
4 years ago

Wow! DimaMD..that totally works!. It covers every single possible date that my report throws out without any gaps..I cannot thank you enough.

Kind Regards

Joe