Forum Discussion

ROG's avatar
ROG
Responsive Resident
3 years ago

User Acitivities dax help

Hi guys,

 

I have created a report to show the users activities, which is not the Audit logs as I don't access.

On the table below, I have the users name, and the number os activities they have done.

I would like to create a dax to show me the numbers of users that have the userAcitvity_type = ViewReport AND AnalyzedByExecl, on the past 3 months. Can you help me, please?


Many thanks!

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi ROG ,

     

    Your calculation is based on data model. Please share a sample file with me and show me a screenshot with the result you want. This will make it easier for me to find the solution.

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.