Forum Discussion

TrentS's avatar
TrentS
Icon for Helper IV rankHelper IV
2 years ago
Solved

Best approach for Date sequence check

Good day to all,   I have about 20 events/dates in a shipping sequence that I need to run a check on. I need to determine two things: 1. Any missing dates in the sequence (think missing scans dur...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    TrentS 

    you can create two measures

    Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table', ISBLANK('Table'[order processed])||ISBLANK('Table'[packed])))
    Measure 2 = CALCULATE(COUNTROWS('Table'),FILTER('Table', 'Table'[packed]>'Table'[shipping]))
     
    or create columns
    missingdate = if(ISBLANK('Table'[order processed])||ISBLANK('Table'[packed]),1,0)
    wrongdate = if('Table'[packed]>'Table'[shipping],1,0)
     
    then you sum the column to get the total number
     
    pls see the attachment below
     
     

     

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper User
2 years ago

TrentS 

you can create two measures

Measure = CALCULATE(COUNTROWS('Table'),FILTER('Table', ISBLANK('Table'[order processed])||ISBLANK('Table'[packed])))
Measure 2 = CALCULATE(COUNTROWS('Table'),FILTER('Table', 'Table'[packed]>'Table'[shipping]))
 
or create columns
missingdate = if(ISBLANK('Table'[order processed])||ISBLANK('Table'[packed]),1,0)
wrongdate = if('Table'[packed]>'Table'[shipping],1,0)
 
then you sum the column to get the total number
 
pls see the attachment below