Forum Discussion
Count on condition from multiple sorting condition
Hi, I'm trying to create a new custom column for my table which it's gonna count the sort order from other collumns on some condition: 1. it's should be on the same date 2. it should be sorted ...
hi Ashish_Mathur ,
thank you very much for your help.
it's close from what I'm looking for, but the problem is, with your code rows with date earlier than 2019/06/14 would also be counted.
I need rows to be counted only on the same day
Hi,
This calculated column formula works
=CALCULATE(COUNTROWS(Data),FILTER(Data,Data[date_column]=EARLIER(Data[date_column])&&Data[value_column]>=EARLIER(Data[value_column])))
Hope this helps.
hi Ashish_Mathur ,
thank you very much for your help.
it's close from what I'm looking for, but the problem is, with your code rows with date earlier than 2019/06/14 would also be counted.
I need rows to be counted only on the same day
Hi,
Your formula is not the same as mine. You are missing the EARLIER() before the &&
sorry for that.
it works perfectly now!
thank you very much, really appriciate it!
regards,