This week I’m doing something a little bit different. I wanted to post a challenge that I think could apply to many business scenarios, and see the different approaches that people might take to get to the same solution.
The challenge is the following:
Based on Date field of when a Client last had an Activity (Last Activity Date), create a Power BI report with a Slicer that lets the user filter Clients based on “Last Active 30 days, 90 days, All Time”
Below is the expected functionality in the Power BI report:
Here is a link to download the .pbix file with the sample data loaded. Use this to mockup your solution. Post your solution in the comments below and let me know how you arrived to it. I will post my solution by the end of the week.
Happy problem solving!
Activity = switch(true(), datediff(Clients[Last Activity Date],TODAY(),DAY)<30,"30DAYS", datediff(Clients[Last Activity Date],TODAY(),DAY)<90,"90DAYS","ALL")
Hi AR – your calculated column only returns 8 clients for “Last 90 Days” – it should include those clients in the “Last 30 Days” as well!
Amazing post! Thank You for sharing such helpful information!