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.
Hi,
I have a table called "Actions" and another table called "tb_Calendar" which is a calendar table.
Action Name | Created Date | Closed Date | Status (Open or Closed)
I need a view were I can see the amount of actions that were opened during a period.
It should show that in January I had 40 actions opened, February 30, etc...THis is based on the Created Date and Closed Date collums.
The problem is that i'm only getting the number of actions that were opened during that period and not the amount of all actions that were opened during that period.
Solved! Go to Solution.
Hi,
I just responded to a similar post here. Please see the link which i have shared there.
It was not the perfect solution, but helpmed to have a insight on how to solve the question.
I created a table based on this tutorial with all the Weeks from my calendar table.
https://gorilla.bi/power-query/date-table-with-monthly-increments/
Them I used Added a Collum:
Opened Actions =
COUNTROWS(
FILTER(
'AllActions',
'AllActions[Created Date] < 'tb_Followup '[Date] && ('AllActions[Closed Date] > 'tbFollowup'[Date] || 'AllActions[Closed Date] = BLANK())
))
Hi,
I just responded to a similar post here. Please see the link which i have shared there.
It was not the perfect solution, but helpmed to have a insight on how to solve the question.
I created a table based on this tutorial with all the Weeks from my calendar table.
https://gorilla.bi/power-query/date-table-with-monthly-increments/
Them I used Added a Collum:
Opened Actions =
COUNTROWS(
FILTER(
'AllActions',
'AllActions[Created Date] < 'tb_Followup '[Date] && ('AllActions[Closed Date] > 'tbFollowup'[Date] || 'AllActions[Closed Date] = BLANK())
))
You can consider the following:
Measure =
CALCULATE (DISTINCTCOUNT(Actions[Action Name]), ALLEXCEPT(tb_Calendar[Month]),FILTER(Actions,Actions[Status]="Open"))
Hi,
Thanks for the reply, but I believe it doesn't work.
The Status "Open" changes over time. So...In January an action might have been as "Open" and now It can show as "Closed".
I need to compare the dates.
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |