I am looking to understand how I can create a measure that will produce a score when certain criteria have been met. Most of the scenarios will be around dates.
To keep things simple, as an example - if a customer has completed “Activity A” in the last 3 months, they get 5 points. Then if they have completed “Activity B” in the last 6 months, they get 10 points. I then need to be able to total up the points to get an overall score. The measure will need to return a zero if there is no date present for the activity. It will also have to return a zero if the time period has passed.
I couldn’t find any examples but I am sure I had seen something out there.
This is a major project for me in 2019 so I’d appreciate any insight or help.
I plan to create a brand new dataset for the reports, so blank canvas all round.
Thanks in advance