This video is brilliant. It solved a massive challenge I had with my dashboard. I have another challenge though. Is there a way I can make List.Dates output only Weekdays?
Why would that not be possible with datetimes? The only difference is that the granularity would be on the, say, minute level instead of the day level. Everything else remains the same.
It depends how your data is constructed, but the logic should be the same, what may differ is the functions and operations used. Depending on your data, you can do what Brian did here, or if you are comparing lists and working on lists and not tables then you might use List.Contains, List.Difference, List.RemoeItems.
Suppose we have 4 dates and I want to understand if all of these mutually overlap. Eg: 1-2, 1-1.45, 1-1.30 and 1- 1.15 - all of these overlap mutually. Could you please help