Forum Discussion

Helper V

3 years ago

Solved

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...

Need Help

Show and Tell

Ahmedx
3 years ago
pls try this
https://1drv.ms/u/s!AiUZ0Ws7G26RiVs3N2tYGq_Fvyyt?e=NT4v85

New_be

Helper V

3 years ago

Sorry for the delay,

Now I attached an example file from pbix. 😊
https://www.sendbig.com/view-files/?Id=d1066bf8-70e4-ae8b-0b06-20178a8509ad

The sumx shows weird value.

New_be

Helper V

3 years ago

Hi Ahmedx , I already attached pbix file for your reference.

Ahmedx
Super User
3 years ago
pls try this
https://1drv.ms/u/s!AiUZ0Ws7G26RiVs3N2tYGq_Fvyyt?e=NT4v85
- New_be
  Helper V
  3 years ago
  Hi Ahmedx ,
  
  Thank you so much! It solved the issue. In my case I just need another summarize function inside sum. Bless you!

Forum Discussion

Conditional sum: Consecutive date and non-consecutive date

Related content

Unpivot non-consecutive columns

calculation between non consecutives rows

Sum with non consecutive date period selection

Compare Any 2 non-consecutive Rows (PowerQuery)

Detect Non-consecutive values in a column