Forum Discussion
Solved
Filtering Data to Determine User Access on Specific Dates
Hello, I'm a beginner in PowerBI and i got asked to try and create a couple reports. I'm not really sure what would be the correct terminology for what I'm trying to do so didn't have much luck when ...
Hi MuFeR
For your second requirement, you can create the following measure to determine if the system was accessed on the specific date.
Today = IF(SELECTEDVALUE('Table'[RequestCompletionDate])=TODAY()&&SELECTEDVALUE('Table'[RequestType])="Grant access",1,0)Then you can filter the value of measure in the filter.
Result:
For your third requirement you can use the following measure to determine who has access to the system for the duration of an entire year.
Time period = IF(COUNTROWS('Table')=1 && SELECTEDVALUE('Table'[RequestType])="Grant access",1,0)You can then filter the corresponding values in the filter and work with the slicer to achieve the results you want.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
lbendlin
Super User
Super UserHow many users? How many entries in the access reference table?
You may not need to torture Power Query for that (except maybe to indicate From/To periods).
