Forum Discussion
Delivery indicators classification
Hi Cherie,
Many thanks for your reply and time to explain. However, this solution does not work for me at all. When I try to create a new measure with the formulae you provided, the result I get is ''A single value for column 'LatestDateToBeDelivered' in table 'XY' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count or sum to get a single result."
Wouldn't it make more sense to make it similar to your but with the full formula expression where I can say something like this:
IF([LatestDateToBeDelivered] >= [ActualDateOfDelivery], >= 3, 1)
Sorry for my bad DAX skills, but I would read this if latest date to be delivered is greater or equal to actual date of delivery, for the value of 3, then classify as 1. Does this make sense?
Hi Anonymous
You may try below measure with DATEDIFF function.Then use it in filter.
Measure =
IF (
DATEDIFF (
SUM ( Table1[LatestDateToBeDelivered] ),
SUM ( Table1[ActualDateOfDelivery] ),
DAY
) >= 3,
1
)
Regards,
Cherie
Hi v-cherch-msft ,
Unfortunately, this does not help either. Although, I did manage to use DATEDIFF function to retrieve some values back in the form I would like them. Many thanks for your help!
Hi Anonymous
Could you share some data sample and expected output?You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Cherie