The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
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
User | Count |
---|---|
17 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
9 | |
8 |