This content has been marked as final. Show 2 replies
Need your help if you can:
I am struggling with a measure I am trying to create.
In order to count the number of customers who are within their ordering frequency I have use the following:
if(Aggr(max([Last Order Date]),
“Aggr(max([Last Order Date]),[No/Name])+ sum(CustomerDays)/sum(OrderCounter)” uses the “Last Order Date” to establish when the customers are next due to order.
This works fine within a table visual however I would like to display the count as a KPI visual so the If statement does not work.
What is the best way for me to achieve this count?