Forum Discussion
Calendar Period Rollup Count
Hi,
I have a Bar Graph showing the count of items in an Axis by YearQuarter. Right now the count works because I have a relationship to the calendar by the created date.
The problem is that I'm being asked to also count the items that have not been closed by that quarter, and these have to be selectable for crossfiltering. So, to clarify, the Axis 2022Q1 should count everything openened in the same Quarter, but it should also include anything that has not been closed from previous Quarters.
I'm working with columns for CreatedDate, ClosedDate, ItemID.
So the only solution that I think it's possible to make it selectable is to create a join table like ItemID,YearQuarter. Do anyone knows how to achieve this? How do I create a Join with a criteria like this in DAX?
I you would take a different approach let me know please.
Thanks,
1 Reply
- amitchandak
Super User
AlfredoBI , Based on What I got you can create a date table and create a qtr year in that
Try like active employee
In case you keep both joins inactive, you can remove cross filter
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
