Forum Discussion
Help Needed with Date Measure
Hi,
There are several ways to do this and it all depends on how your table is structured, how you plan on using your meassure and so on...
For example if all your rows in the sales order table corresponds to separate orders and all you want to do is to get an count of the orders that has passed due date the simple meassure like this will work:
Orders past duedate = COUNTROWS(FILTER(Orders,Orders[DueDate]<TODAY()))
But I guess there will be other factors to consider as well but without knowing more about your specific case...
Br,
Magnus
Hi,
There are several ways to do this and it all depends on how your table is structured, how you plan on using your meassure and so on...
For example if all your rows in the sales order table corresponds to separate orders and all you want to do is to get an count of the orders that has passed due date the simple meassure like this will work:
Orders past duedate = COUNTROWS(FILTER(Orders,Orders[DueDate]<TODAY()))
But I guess there will be other factors to consider as well but without knowing more about your specific case...
Br,
Magnus
Hello Magnus
Thanks for responding. that is exactly the soloution i was looking for.
Very much appreciated .
and have a great day :smileyhappy:
