Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I'm using this standard Dax to calculate total number of open tickets each month. The issue is that I only want to track tickets that are open longer than 180 Days or 6 months.
From the table you can see the this ticket was open for 15 months, the days open is for the total days open, I want to know how old it is EACH month roughly adding 30 days to the next month so that its not flagged until it hits 180 days of age.
I'm trying to show this in a line chart, but without the proper age filter it just shows all open tickets by each month.
@greekjgg , Add additional in your filter
datediff(Table[Open date], CurrentDate, day) > 180
Also, I doubt you can active join with the date(With current statement) .
refer active employees here
or file
Like This?
I refered to your blog to build the initial dax, but wasn't much help for the age part.
When I add that filter the results are way off
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |