Forum Discussion
Measure to Segment User Activity
bigfun ,
Yes, SWITCH Statement is how I would approach this as well:
LevelofActivity = SWITCH( TRUE(), [Monthly Logins] > 10, "High", [Monthly Logins] >=5, "Medium", "Low" )The last line, is your "else" condition. You can specify your third condition <5 if you want to make it clearer to yourself or others.
Hope this helps.
Regards,
bigfun ,
Yes, SWITCH Statement is how I would approach this as well:
LevelofActivity = SWITCH(
TRUE(),
[Monthly Logins] > 10, "High",
[Monthly Logins] >=5, "Medium",
"Low" )The last line, is your "else" condition. You can specify your third condition <5 if you want to make it clearer to yourself or others.
Hope this helps.
Regards,
This is perfect... now I just need to figure out how to free up or not use as much memory processing it.. haha
bigfun ,
Glad I could help. I use SWITCH throughout all of my numerous reports. Have never had an issue with memory or resources. Perhaps something else in your model is causing this. Unfortunately, this is out of my scope.
Curious if you have even put a condition on a switch statement.. For example:
I have a column that has a version# 1.0, 2.0, etc, and I only want to run the switch statement on the rows that are version 2.0.
