Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Bit of a DAX challenge here (or suggest a better alternative).
I have a list of users and timestamps when they have logged in. I also have a calendar table. I want to split these users into four categories:
No usage
Steady Usage
Decreasing Usage
Increasing Usage
The split should be based on the trend of # of weekly logins in the last three months.
Help much appreciated!
Hi @MaxW,
Not sure how you have the setup of your data and how you are calculating the 4 levels of usage but I have made this setup:
Usage = VAR Usage_user = COUNT ( TimeStamps[User] ) RETURN CALCULATE ( IF ( Usage_user = BLANK (); 0; Usage_user ) ) Usage text = SWITCH ( TRUE (); [Usage] = 0; "No Usage"; [Usage] <= 3; "Decreasing Usage"; [Usage] <= 5; "Steady Usage"; "Increasing USage" )
Then just add them to your visuals:
My data only has information for the 3 month but if you need the formulas can be adjusted to get the 3 months as you need, just tell me how are you calculating the 3 month back is it from current date or selected from a slicer, also you need to define how you are considering the increasing decreasing values.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |