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/2018

 

I want to count the number prior to this date.

 

Thanks,

 

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

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community 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