I have a below table :
and I need to calculate the the count like below:
so For each ticket add one to the count open/month from the month the ticket was opened through (and including) the month it was closed.
here is my below data source
@sandip , refer this can help
Just do distinct count of months
Proud to be a Super User!
I have used the below expression,
and I have created a Date table like below:
have you solved this or are you still struggeling with it?
Hi @sandip ,
See if the following thread helps:
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.