cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Consultant001 Frequent Visitor
Frequent Visitor

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,

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Pass Date Gaps

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

6.png

create a column

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

 

Best Regards

Maggie

1 REPLY 1
Community Support Team
Community Support Team

Re: Pass Date Gaps

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

6.png

create a column

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

 

Best Regards

Maggie