Forum Discussion
Help Needed with Date Measure
Hello
I really need some help with this one.
I have a table with sales order information taken direct from a SQL database. The orders have a due date coloum. I want to count all of the orders where the due date has passed todays date . so any orders with a due date of yesterday will be counted but orders with a due date of tomorrow will not.
Can this be done ?
many thanks
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
2 Replies
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:
