Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago
Solved

Occurrence : Column formula help

Hello Team,   Can you help me to get column formula for occurrence as mentioned in attachment. PBIX: Sample file Excel Formula: =MAX(IF(B2:B6=B2,ROW(B2:B6)-ROW(INDEX(B2:B6,1,1))+1))   Reg...
  • Chandrashekar's avatar
    Chandrashekar
    3 years ago

    Hello,

     

    got the answer.

    Occurence=
    COUNTX(FILTER ( Sheet1, EARLIER ( Sheet1[Number]) = Sheet1[Number] && EARLIER(Sheet1[Month])<=[Month]),
        Sheet1[Number])
     
    Regards,
    Chandrashekar B
Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago

Hello,

 

Can anyone help on column formula.

 

Regards,

Chandrashekar B

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
3 years ago

Hello,

 

got the answer.

Occurence=
COUNTX(FILTER ( Sheet1, EARLIER ( Sheet1[Number]) = Sheet1[Number] && EARLIER(Sheet1[Month])<=[Month]),
    Sheet1[Number])
 
Regards,
Chandrashekar B