Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi y'all.
I thought this would be simple, no I bet this is simple, but somehow the right solution manages to escape me.
I've to tables: Calendar and Data. Calendar is joined to Data by reporting date. All good so far.
I need cumulative distinctcount of all unresolved tickets.
So this is what I accomplished so far:
calculate( distinctcountnonblank(Data[key]),
Filter(Data, Data[resolutiondate] <= endofquarter(Calendar[Date]) || isblank(Data[resolutiondate]))
)
Now to the hard part: all tickets not solved by end of the quarter should be summed up. E.g.
coming into 2020/Q1 there are 7 tickets, and 3 new tickets are added to the sum during the quarter. And finally 4 tickets are resolved by the end of the quarter. So the number of tickets for 2020/Q1 should be 7+3-4=6. How do I manage this. The tickets coming into 2020/Q1 can be anywhere from yesterday to dawn of time.
Thank you!
Hi @GoingIncognito ,
Could you please share some sample data and the expected result to have a clear understanding of your question? I can do some tests for you.
You can save your files in some cloud sharing platforms and share the link here.
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Yuna
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
117 | |
101 | |
71 | |
61 |