Forum Discussion
group by
Hello , I would like to group my table like that : 8:00:00 -> 17 8:01:00 ->42 8:02:00 -> 29(27+2) 8:03:00 -> 36 (21+5+10) 8:04:00 -> 9 ( 7 + 2) I tested different w...
Hi,
is there any reason the data needs to stay in this format, could you not split it into 2 tables in power query and append them together so that the time is in one column and count in another. Then use a simple calculate(sum?
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍