Create a Distinct Count of orders within a Datesbetween parameter

[Anonymous]

Hi,

Im trying to get a distinct count of orders between two dates of orders,

At the moment i have this but it returns a Null;

Dist Orders in 2014 = CALCULATE(DISTINCTCOUNT('TableName'[OrderID]), DATESBETWEEN('TableName'[Date], 01/10/2013, 30/09/2014))

The OrderID Column contains the order ID's for each line item, and each full order ID in unique for if there is 5 or 6 line items to an order we will see the same orderID 5 or 6 times, so to get a true unique orders in FY 2014 i need a distinc count between 10/13 and 09/14 if anyone can help?

Thanks,

Josh

[parry2k · Accepted solution]

Seems like you have DATE table that has relation with orders table:

Try this:

Dist Orders in 2014 = CALCULATE(DISTINCTCOUNT('TableName'[OrderID]), 
DATESBETWEEN('TableName'[Date], 
    DATE(2013,10,1),  
    DATE(2014,09,3)  
  ))  

[Anonymous]

Thats spot on,

Had a weird feeling it was my formatting that was off,

Dist Orders in 2014 = CALCULATE(DISTINCTCOUNT('TableName'[OrderID]), DATESBETWEEN('TableName'[Date], DATE(2013, 10, 01), DATE(2014, 09, 30)))

Thanks!!