Hi All,
I have a dax model, where I identify new users marked as "1" in a field.
The new user identification appears only one time to those records which consists new users first time in the model.
e.g. for a given period the data as follows:
User A - 0
User A - 0
User A - 0
User B - 1
User B - 0
User A - 0
User A - 0
User A - 0
User B - 0
User A - 0
User C - 1
User C - 0
In the above data "User A" does not qualify as a new user as he was an old user from previous period. But users "B" & "C" are new users in the given period.
I want to create a measure which calculates "countrows" of new users in the given period.
Expected results:
zero for User A
3 for User B
2 for User C
Any help is appreciated.
Bookmarks