Forum Discussion
New_be
3 years agoHelper V
Conditional sum: Consecutive date and non-consecutive date
Hi expert, Scenario: I have a report that needs me to calculate the frequency of absenteeism impact per employee. The condition is, 1 date will be count as 1, and consecutive date will also be c...
- 3 years ago
Ahmedx
3 years agoSuper User
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://1drv.ms/u/s!AiUZ0Ws7G26RiUi13Bf9jaud2VWf?e=ZiiHhm
- New_be3 years agoHelper V
Hi Ahmedx ,
Thank you for your sharing. I learn new things today. 😊
But in my case this didn't work since my table have multiple employee for 1 date:Below is my measure for the offset:
When I tried, an error message popup "offset relation parameter contains column "DateStamp" which matches more than one row or filter context". Is the issue happen because of that? Thank you for your help 🙏🏻