Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
dombot5000
New Member

DAX - New or Existing User

We have a table of actions for users that includes a PersonID and an ActionDate

 

1. We need to identify whether users are NEW USER or EXISTING USER when we use month/date/year slicers (there is a Date Dimension)

 

2. We created a NewUserFlag to highlight first action to define NEW USER or EXISTING USER

 

3. If we were to filter calendar year to 2019 the report would need to show that PersonID = 101 was a NEW USER in that period, but pull back both actions (i.e. Key 1 & 4)

 

I'm guessing we need something that sees where NewUserFlag is both NEW USER and EXISTING USER in selected period and allocate all associated actions to a NEW USER

 

Key   PersonID     ActionDate    NewUserFlag

1       101              01/01/2019    NEW USER

2       102              03/05/2019    NEW USER

3       103              03/06/2019    NEW USER

4       101              01/05/2019    EXISTING USER

 

Any help appreciated!

 

dombot5000

 

1 REPLY 1
Anonymous
Not applicable

What does this mean:

 

3. If we were to filter calendar year to 2019 the report would need to show that PersonID = 101 was a NEW USERin that period, but pull back both actions (i.e. Key 1 & 4)

 

What do you mean by "pull back both actions"?

 

Please state clearly what it is you want by giving as much detail as possible. Please always remember that we DO NOT KNOW your model. Also, if you want any specific reports, please make them up and paste here so that we see what you want.

 

Thanks.

 

Best

Darek

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.