Forum Discussion
Group Table data together showing changes
Figured it out, using the NEW_IndexCat (as above)
NEW_Offset = MAXX(FILTER(ALL(Fact_Task), Fact_Task[JobNumber] = EARLIER(Fact_Task[JobNumber]) && Fact_Task[NEW_IndexCat] +1 = EARLIER(Fact_Task[NEW_IndexCat]) ), Fact_Task[TaskStatusSk] )
HI APS_SW,
My expression required the 'job number' and 'task status' as category fields, you can add them to the visual to help formula get correct result and display the each status last change date based on job number and task status.
Regards,
Xiaoxin Sheng
Thank you Anonymous but as shown on the previous screenshot filters on the visuals do not help.
I have made some progress however, adding a index column based on category
NEW_IndexCat =
VAR JN = Fact_Task[JobNumber]
VAR NT = FILTER( Fact_Task, Fact_Task[JobNumber] = JN)
RETURN RANKX( NT, Fact_Task[TaskStatusDate],,ASC)
And now I'm attempting to use it to pull in the previous value, although right now it returns a (blank)
NEW_Previous Status =
SUMX(
FILTER (
Fact_Task,
Fact_Task[JobNumber] = Fact_Task[JobNumber]
&& Fact_Task[NEW_IndexCat] = Fact_Task[NEW_IndexCat]-1
),
Fact_Task[TaskStatusSk]
)
The issue I believe is in the line:
&& Fact_Task[NEW_IndexCat] = Fact_Task[NEW_IndexCat]-1
Changing it to an absolute value returns only the single line; I highly suspect I am trying to do things incorrectly.
I'll update this thread if thigns change but any advice or examples / fixes that would make my life easier will be much appriciated.
Figured it out, using the NEW_IndexCat (as above)
NEW_Offset = MAXX(FILTER(ALL(Fact_Task), Fact_Task[JobNumber] = EARLIER(Fact_Task[JobNumber]) && Fact_Task[NEW_IndexCat] +1 = EARLIER(Fact_Task[NEW_IndexCat]) ), Fact_Task[TaskStatusSk] )