Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    7 years ago

    Hi,

    Your formula is not the same as mine.  You are missing the EARLIER() before the &&

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Ashish_Mathur 

       

      sorry for that.

      it works perfectly now!

      thank you very much, really appriciate it!

       

      regards,

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        7 years ago

        You are welcome.  If my reply helped, please mark it as Answer.