Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have these 2 tables that are connected through timeID, I need to create a dax for Open, Close and Backlog incidents on monthly basis for example in the month of may count the number of incidents that are open and have open date started in May, No of tickets closed in May and No of backlog tickets that were opened before May and are still open in May. I have a month slicer and my chart should show open, close and backlog tickets versus months on x axis.
Hey @srahzafar9 ,
you can get the amount of open or closed with the following measure:
Open Incidents =
CALCULATE(
COUNTROWS( Table2 ),
Table2[Status] = "Open" && Table2[Type] = "Incident"
)
As your data is connected by TimeID you just have to put the desired time frame in a visual, for example May, and you can analyze what you want.
User | Count |
---|---|
50 | |
44 | |
18 | |
14 | |
14 |
User | Count |
---|---|
107 | |
58 | |
29 | |
21 | |
16 |