Forum Discussion

Frequent Visitor

4 years ago

Solved

If Else Date Question

Hi All, Ratting around in my brain to see how this would work, here is my data: No. Stage Date 1 P 10/05/2022 1 F 12/08/2022 1 A 2 P 2 F 15/06/2022 2 A 22/0...

Need Help

Tahreem24
4 years ago
CallumJ Create a Column like this:

Column =

VAR A_ = CALCULATE(MAX(StageTable[Date]),StageTable[Stage]="A",ALLEXCEPT(StageTable,StageTable[No.]))

VAR P_ = CALCULATE(MAX(StageTable[Date]),StageTable[Stage]="P",ALLEXCEPT(StageTable,StageTable[No.]))

VAR F_ = CALCULATE(MAX(StageTable[Date]),StageTable[Stage]="F",ALLEXCEPT(StageTable,StageTable[No.]))

RETURN SWITCH(TRUE(),

A_=BLANK(),F_,

P_=BLANK(),A_,

F_=BLANK(),A_,

A_

)