Forum Discussion

Tom_pbi's avatar
Tom_pbi
Regular Visitor
4 years ago
Solved

Count Help

Hi all,   I am having an issue getting the correct formula using COUNT. My scenario is that I have a column of dates and I want another column that counts the occurence of the same date cummulative...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Tom_pbi ,

     

    Please add the Index column in Power Query Editor.

     

     

    Then create the column or measure.

     

    Column = COUNTROWS(FILTER('Table','Table'[Date] = EARLIER('Table'[Date]) && 'Table'[Index] <= EARLIER('Table'[Index])))
    Measure = COUNTROWS(FILTER(ALLSELECTED('Table'),'Table'[Date] = MAX('Table'[Date]) && 'Table'[Index] <= MAX('Table'[Index])))

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi Tom_pbi ,

 

Please add the Index column in Power Query Editor.

 

 

Then create the column or measure.

 

Column = COUNTROWS(FILTER('Table','Table'[Date] = EARLIER('Table'[Date]) && 'Table'[Index] <= EARLIER('Table'[Index])))
Measure = COUNTROWS(FILTER(ALLSELECTED('Table'),'Table'[Date] = MAX('Table'[Date]) && 'Table'[Index] <= MAX('Table'[Index])))

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.