Calls Waiting To Be Returned

Hi otl_86 ,

Test the below ,first create a date table:

= Table.FromColumns({List.DateTimes(#datetime(2022,1,1,0,0,0),365*1440,#duration(0,0,1,0))}, type table[DateTime=datetime])

Then use the below measure:

sumaccount = IF([HOURcount1]<>BLANK(), CALCULATE(COUNTROWS('Table'),'Table'[START_DATEH]<=MAX('Table 1'[DateH])),BLANK())

sumaccount2 = if([sumfinal]<>BLANK(),CALCULATE(COUNTROWS('Table'),'Table'[START_DATEH]<=MAX('Table 1'[DateH])),'Table 1'[sumaccount])

sumfinal = IF([finalcount1]<>BLANK(), CALCULATE(COUNTROWS('Table'),'Table'[condateh]<=MAX('Table 1'[DateH])),BLANK())

sumfinal2 = IF([sumaccount]<>BLANK(),CALCULATE(COUNTROWS('Table'),'Table'[condateh]<=MAX('Table 1'[DateH])),[sumfinal])

Then create visual:

When I imported your data, the month and day were not accurately judged, so the results will be a little different, according to your actual situation to adjust.
The results will be adjusted according to your actual situation.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien