Forum Discussion
Calculate Daily Active User
Hi,
I want to display a trend line of active users every day based on start and end dates. I am able to get to this displayed but I am struggled with adding a slicer to filter the company users are in.
here is the sample data
| Company | Name | Start | End |
| ABC | Liam | 6/1/2019 | 3/1/2020 |
| ABC | Noah | 7/1/2019 | 2/1/2020 |
| ABC | William | 8/1/2019 | 1/1/2020 |
| DEF | James | 9/1/2019 | 3/1/2020 |
| DEF | Oliver | 10/1/2019 | 2/1/2020 |
| DEF | Benjamin | 11/1/2019 | 1/1/2020 |
| GHI | Elijah | 12/1/2019 | 3/1/2020 |
| GHI | Lucas | 1/1/2020 | 2/1/2020 |
| GHI | Mason | 2/1/2020 | 2/1/2020 |
| GHI | Logan | 3/1/2020 | 3/1/2020 |
I created a date table and a calculated column using:
Refer to my blog on same lines. Check for current employee
I read this through a couple times and now I understand it. You can't use a column for this because columns are not dynamic. Columns are calculated at the time of data load and thus cannot be dynamic via user interaction like selecting a company. What you want is the Open Tickets measure I created here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
Since it is a measure, it can be dynamic based upon user interaction.
3 Replies
- amitchandak
Super User
Refer to my blog on same lines. Check for current employee
- Greg_Deckler
Community Champion
I read this through a couple times and now I understand it. You can't use a column for this because columns are not dynamic. Columns are calculated at the time of data load and thus cannot be dynamic via user interaction like selecting a company. What you want is the Open Tickets measure I created here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364
Since it is a measure, it can be dynamic based upon user interaction.