Hi All,
I am struggling with a calculation for number of exam candidates who became members in a particular month, I have the below:
Joiners:=
COUNTROWS (
INTERSECT (
VALUES ( Exams[Contact Number] ),
EXCEPT (
VALUES ( Members[Contact Number] ),
CALCULATETABLE (
VALUES ( Members[Contact Number] ),
Members[Status] = "Current/Active",
FILTER( ALL( Members ), Members[Financial Period] < MIN ( Calendar[Financial Period] ) )
)
)
)
)
The logic is - Everyone who sat this exam AND is active in this month BUT was not active in any previous month.
I'm stuck on the bold line, the table of members active in previous months. Does anyone have any suggestions?
Thanks
Rich
I am struggling with a calculation for number of exam candidates who became members in a particular month, I have the below:
Joiners:=
COUNTROWS (
INTERSECT (
VALUES ( Exams[Contact Number] ),
EXCEPT (
VALUES ( Members[Contact Number] ),
CALCULATETABLE (
VALUES ( Members[Contact Number] ),
Members[Status] = "Current/Active",
FILTER( ALL( Members ), Members[Financial Period] < MIN ( Calendar[Financial Period] ) )
)
)
)
)
The logic is - Everyone who sat this exam AND is active in this month BUT was not active in any previous month.
I'm stuck on the bold line, the table of members active in previous months. Does anyone have any suggestions?
Thanks
Rich