Forum Discussion

Frequent Visitor

7 years ago

Solved

Counting rows

Hi all, I'm trying to count the total rows where SOLLAST is less than or equal to the Date. I want something like this.

7 years ago

ozgurozturk98 Please try this..

TotalRows = CALCULATE(COUNT(TestCount[SOLLAST]),
                      FILTER(ALL(TestCount),TestCount[SOLLAST]=EARLIER(TestCount[Date])))

Frequent Visitor

7 years ago

Anonymous

Well you can consider the left column (date) as the current date. The SOLLAST describes the total orders.

E.G.

On the date 10-6-2018 there are two times a solllast with the same date. So ''Date" has a total row of 2.

Community Champion

7 years ago

ozgurozturk98 Please try this..

TotalRows = CALCULATE(COUNT(TestCount[SOLLAST]),
                      FILTER(ALL(TestCount),TestCount[SOLLAST]=EARLIER(TestCount[Date])))