Hi,
I created (got from the web) the following measure to identify all new users (i.e. "Uploaders") starting from Day >= 10/24/21:
It seems to work fine. HOWEVER, when I use the above measure inside a new one such as below, the numbers do not stay consistent:
As you can see from the attached picture, the number that should come up on week 40 for Week New Uploaders is 254. Instead it gives me 263 and I can't understand why for the life of me. The ultimate goal is to create measures that track progress of new uploaders at a Week, Month, Season, and Year level.
Any feedback is welcome please.
Thank you.
I created (got from the web) the following measure to identify all new users (i.e. "Uploaders") starting from Day >= 10/24/21:
Excel Formula:
Measure New Uploaders (Starting wk39):=
(CALCULATE( DISTINCTCOUNT([customer_id]) ,
FILTER( VALUES( Uploads[customer_id] ) ,
CALCULATE( COUNTROWS( Uploads ) ,
FILTER( ALLSELECTED( 'Retail Calendar' ) , [Day (454)] < MIN( 'Retail Calendar'[Day (454)] ) &&
[Day (454)] >= DATE( 2021, 10, 24) ) ) = 0 ) ,
FILTER( 'Retail Calendar', [Day (454)] >= DATE( 2021, 10, 24 ) ) )
It seems to work fine. HOWEVER, when I use the above measure inside a new one such as below, the numbers do not stay consistent:
Excel Formula:
Measure Week New Uploaders:=
CALCULATE( [New Uploaders (Starting wk39)] , FILTER('Retail Calendar', [Previous Week (454)] = "LAST_WTD" ) )
As you can see from the attached picture, the number that should come up on week 40 for Week New Uploaders is 254. Instead it gives me 263 and I can't understand why for the life of me. The ultimate goal is to create measures that track progress of new uploaders at a Week, Month, Season, and Year level.
Any feedback is welcome please.
Thank you.