Forum Discussion

Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

atul9063

 

try this

 

Create a calendar table and then this MEASURE

 

Measure =
VAR PreviousMonthUsers =
    CALCULATETABLE (
        DISTINCT ( Table1[Useritemid ] ),
        PREVIOUSMONTH ( Table1[Date] )
    )
VAR CurrentMonthUsers =
    DISTINCT ( Table1[Useritemid ] )
RETURN
    IF (
        ISEMPTY ( PreviousMonthUsers ),
        COUNTROWS ( CurrentMonthUsers ),
        COUNTROWS ( INTERSECT ( PreviousMonthUsers, CurrentMonthUsers ) )
    )