Returning Users Month over Month

DAX
1

Hi, I’m creating some numbers around the People who view our PowerBi Reports. More specifically I am calculating numbers for report viewers who come back month over month.

I’ve been able to generate the correct DAX to calculate People who return each month. But I’m not able to revise the calculation to get the Average number of returning people?

Attached is a PBX with an easy sample dataset along with the DAX i wrote for returning viewers. Any help would be appreciated here…
eDNA Returning Viewers.pbix (130.4 KB)
Returning Report Viewers.xlsx (17.7 KB)

*Returning Viewers =

VAR Unique_Users_Currnet_Period =
CALCULATETABLE(
VALUES(‘Report Viewers’[Viewer]))

VAR Unique_Users_Prior_Month =
CALCULATETABLE(
VALUES(‘Report Viewers’[Viewer]),
DATEADD(‘Master Date Table’[Date], -1,MONTH))

RETURN
COUNTROWS(INTERSECT(Unique_Users_Currnet_Period,Unique_Users_Prior_Month))

2

Hi @chad.sharpe ,

For calculating the average number of returning viewers, you can refine your existing DAX measures. To get detailed assistance and explore more solutions, please run your query on the Enterprise DNA Data Mentor site here: Enterprise DNA Data Mentor.

Best regards,

Enterprise DNA Support Team

3

@chad.sharpe ,

Sorry for waiting for answer.

You may check :
eDNA Returning Viewers Avg Viewers.pbix (130.1 KB)

description you can find at Data Mentor thread

Hope it helps