Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

occurances on the same date

Hey guys, i have been struggling with this problem for a little while so hopefully someone here can help me. I havent been using power BI alot so maybe the anwser i quite ovious, however thanks for a...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous ,

 

Not very clear.

 

Try creating a Calculated Column

Occ = COUNTROWS(FILTER('Table','Table'[Activity ID] = EARLIER('Table'[Activity ID]) && 'Table'[End date] = EARLIER('Table'[End date])))

 

Regards,

Harsh Nathani