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