We are seeing a lot of questions about categorical Measures, things like:

  • Lost Customer (Last purchase was over two years ago)
  • Dormant (Last purchase was between two years and a year ago)
  • Active, Loyal Customer...

Unfortunately, right now there is no way to create this kind of measure without using SQL or at the time of data load with Power Query.

It would be great to have IF/THEN capabilities for the measures UI to be able to define conditions to assign a category to the customer.

Category: Measures
Needs Votes
Ideas Administrator

Thank you very much for this idea! we would love to consider it. Optimally we want to wait for more votes to be made in favor of the idea and we will ongoingly check for that. Once more votes were added and we review the idea as part of our planning we will make sure to update.  


The Dynamics 365 Customer Insights team.