I was hoping if you could help me. I have been asked to create this in powerbi for each month:
Month Jan Feb Mar Opening balance 8914 9010 9230 Active Registration 193 2010 1541 Active Subscription -102 -1790 -1290 Closing balance 9010 9230 9481
However I am not sure if its my closing balance or my Opening balance measure is correct. This is what i am getting:
Here are the measure i used:
Opening Balance :
Opening balance = OPENINGBALANCEMONTH([Closing balance],FeeDate[Date])
Active Registration:
Active Registrations =
CALCULATE (
DISTINCTCOUNT ( contacts[contactid] ),
FILTER(contacts, contacts[au_memberstatus] = 827080000),
USERELATIONSHIP(FeeDate[Date],contacts[createdon])
)
Active Subscription:
Active Subscriptions =
CALCULATE (
[Active Registrations] * -1,
FILTER ( contacts, contacts[_au_activesubscription_value] <> BLANK() ),
USERELATIONSHIP(FeeDate[Date],au_subscriptions[CreatedDate])
)
Closing Balance:
Closing balance =
Var running = IF (
[Active Registrations] <> BLANK (),
CALCULATE (
[Active Registrations],
FILTER ( ALL ( FeeDate[Date] ), FeeDate[Date] <= MAX ( FeeDate[Date] ) )
)
)
return
running + [Active Subscriptions]
