Power BI (DAX): Calculating MoM Variance of a Measure Field

Question

I am having a formula which takes a table and converts montly count of distinct customers:

Active Publishers =
CALCULATE(
DISTINCTCOUNT( 'Net Revenue Data'[Publisher Name] ),
'Net Revenue Data'[Active Month] = 1)

amd created a formula which takes Month-over-Month trend which looks like this

and formula for this is

Net Change = 'Net Revenue Data'[Active Publishers] - 
CALCULATE('Net Revenue Data'[Active Publishers], 
PREVIOUSMONTH('Net Revenue Data'[Date (Month)]))

How to create a measure which shows monthly variance of the 'DistinctCountActiveMonths' 

Answer 1

Use the following measures

LM Active Pubs = CALCULATE([Active Pubs],DATEADD('Net Rev 09-14'[Date],-1,MONTH))

Change in Active Pubs = [Active Pubs]-[LM Active Pubs]

Want to learn more about Power BI? Check out today: Power BI course