Forum Discussion

Euro0681's avatar
Euro0681
Helper II
3 years ago

Status Tracking

Hi All, Needing some help on displaying the orders where the status has changed when compared to the previous day. Table on the left showing 2 Order ID's and the table on the right only retur...
Euro0681's avatar
Euro0681
Helper II
3 years ago

So what I'm getting at is using the MAX(Today's DT) and compare each order with previous Today's Date < MAX(Todays DT) and check to see if anything on the order has changed (Status in this example).
Hope this image clears it up

 

tamerj1's avatar
tamerj1
Community Champion
3 years ago

Euro0681 

Place the following measure in the filter pane of the table visual, select "is not blank" and apply the filter. 
FilterMeasure =
VAR T1 =
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[Order ID] ) )
VAR T2 =
DISTINCT (
SELECTCOLUMNS (
T1,
"@Status", 'Table'[Status],
"@Expected", 'Table'[Expected DT]
)
)
VAR T3 =
SELECTCOLUMNS (
TOPN ( 1, T1, 'Table'[Tody's DT] ),
"@Status", 'Table'[Status],
"@Expected", 'Table'[Expected DT]
)
VAR T4 =
SELECTCOLUMNS (
'Table',
"@Status", 'Table'[Status],
"@Expected", 'Table'[Expected DT]
)
RETURN
IF ( COUNTROWS ( T2 ) > 1, COUNTROWS ( INTERSECT ( T3, T4 ) ) )