Forum Discussion

Consultant001's avatar
Consultant001
Frequent Visitor
8 years ago
Solved

Pass Date Gaps

  Hi All   How do I count the number of items prior to a certain date?   I have a pass date coloum and need to count the number of items prior to the pass date.   Example: PASS DATE 6/09/201...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Consultant001

    It is possible to count the number of items prior to the pass date, If my assumtion is not right, could you show some example date and how your dataset structure?

     

    Assmue your table is like this

    create a column

    Column = CALCULATE(COUNT(Table1[item]),FILTER(ALL(Table1),[pass date]<=DATE(2018,6,9)))

     

    Best Regards

    Maggie

v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Consultant001

It is possible to count the number of items prior to the pass date, If my assumtion is not right, could you show some example date and how your dataset structure?

 

Assmue your table is like this

create a column

Column = CALCULATE(COUNT(Table1[item]),FILTER(ALL(Table1),[pass date]<=DATE(2018,6,9)))

 

Best Regards

Maggie