dax meas
1 Topic
Help on How to Create a Measure Based on Start & End Date
Hello! Hoping someone could help me with some advice on how to build a measure I have a table of users, with start and/or end timestamps. The table is an access history for the users. Some users appear multiple times where they have access to multiple org units e.g. Name6, and some others are there multiple times where their access has changed, and the previous access has ended e.g. Name9 What I am trying to show on a year/month basis is the distinct count of users who had an ACTIVE access profile in that period. So for instance if I looked at November 2021 i would see a distinct count of 2... It needs to simultaneously look at the starttimestamp and endtimestamp to determine whether the user was active in that period. Again if we look at Name2 i would expect them to be counted in March 2022 and then April 2022 even though their end timestamp was half way through April E.g file below PBIX FILE Cheers AndySolved1.7KViews0likes7Comments