Open Tickets

Thanks to Phil_Seamark's insightful guidance and examples in his fantastic new book, Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence, I finally "get" the GENERATE fun...

tickets.pbix94 KB

Mathematical

Time Intelligence

Totals

DonPepe

Helper II

3 years ago

Hi Greg_Deckler ,

Thanks for your insight ! it's really sexier than my old solution.

I managed this situation in Power Query by creating a list of all date between my "open" and "close" date and counting the number of different ticket each day.
It works but I got a ton load of line.

Regards,
Don