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...
tamerj1's avatar
tamerj1
Community Champion
3 years ago

Hi Euro0681 

Why not just filter for "Late" status?

  • 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 ) ) )