r/PowerBI•
Pan-Talaimon

Two different counters by Date in one line of a Table

Question

HI, I have a question that seemed simple to me, but even with AI help I couldn't solve it. It gave me some DAX that didn't work.
I have a simple enough setup: A table (lets call it TIcket_report) that has the column Ticket Name, creation date and closed date. There are others info but they don't matter for now. Both dates are formatted as date and time.
I want to create a table that shows how many tickets were created and closed each months. If I just use created date as base and add closed date as value it will only count closed value (what countrows would do) regardless of what date is set up there.

I hope I used the right terms, company is having me use the software in german so I had to guess some translations.

I can't post the actual data, but here is a short example of what it should do:

|| || ||Input (Ticket report)||| ||Create Date|Close Date|Ticket Name| ||01.01.25|01.02.25|Ticket 1| ||01.01.25|01.03.25|Ticket 2| ||01.01.25|01.03.25|Ticket 3| ||05.03.25|01.03.25|Ticket 4| ||05.03.25|01.03.25|Ticket 5| ||05.03.25|01.05.25|Ticket 6| ||05.03.25|01.05.25|Ticket 7| ||||| ||||| ||Wanted result||| ||||| |(year collapsable)|Month|Tickets created|Tickets Closed| ||Jan|3|0| ||Feb|0|1| ||Mar|0|4| ||Apr|0|0| ||May|4|2 |

Posted Jul 28, 2025, 6:13 PM UTC

13
Loading comments…