Help Needed with Date Measure

[thomaskelly]

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

[magsod · Accepted solution]

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

[thomaskelly]

Hello Magnus

Thanks for responding. that is exactly the soloution i was looking for.

Very  much appreciated .

and have a great day