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 two tables one with a row for each month of the year, the other is the table of project members with start dates and end dates. I need to add a column in the first table to count how many active project members there were each month.
I tried this:
# Members = COUNTAX('7 Expert Panel data',and(('7 Expert Panel data'[EOM Start]<='0 Summary table'[Month end]),(OR(ISBLANK([EOM End]),('7 Expert Panel data'[EOM End]>'0 Summary table'[Month end])))))
But to no avail! Please help 🙂
Solved! Go to Solution.
Here's how you can do it in Power BI using DAX:
Active Members =
VAR CurrentMonthEnd = '0 Summary table'[Month end]
RETURN
CALCULATE(
COUNTROWS('7 Expert Panel data'),
FILTER(
'7 Expert Panel data',
'7 Expert Panel data'[EOM Start] <= CurrentMonthEnd &&
(ISBLANK('7 Expert Panel data'[EOM End]) || '7 Expert Panel data'[EOM End] > CurrentMonthEnd)
)
)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Here's how you can do it in Power BI using DAX:
Active Members =
VAR CurrentMonthEnd = '0 Summary table'[Month end]
RETURN
CALCULATE(
COUNTROWS('7 Expert Panel data'),
FILTER(
'7 Expert Panel data',
'7 Expert Panel data'[EOM Start] <= CurrentMonthEnd &&
(ISBLANK('7 Expert Panel data'[EOM End]) || '7 Expert Panel data'[EOM End] > CurrentMonthEnd)
)
)
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
@AndreaA4S glad that it worked out for you. Keep exploring this forum for other issues. 🙂
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!
Hi,
The syntax should work. plz share sample table schema and the dax. alternetive is to use userrelationship function to create relationship with two date column.
User | Count |
---|---|
52 | |
51 | |
20 | |
17 | |
16 |
User | Count |
---|---|
113 | |
46 | |
44 | |
28 | |
22 |