Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)

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)

enter image description hereamd created a formula which takes Month-over-Month trend which looks like this

enter image description here

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' 

1 Answer

0 votes
by (22.5k points)

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    

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

30.5k questions

32.5k answers

500 comments

108k users

Browse Categories

...