Forum Discussion
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...
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_)
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_
)
You are a star, thank you!
