Create a Distinct Count of orders within a Datesbetween parameter

Question

Hi,&nbsp;Im trying to get a distinct count of orders between two dates of orders,&nbsp;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))&nbsp;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?&nbsp;Thanks,&nbsp;Josh&nbsp;&nbsp;

parry2k · Accepted Answer

Seems like you have DATE table that has relation with orders table:&nbsp;Try this:&nbsp;Dist Orders in 2014 = CALCULATE(DISTINCTCOUNT('TableName'[OrderID]), 
DATESBETWEEN('TableName'[Date], 
    DATE(2013,10,1),  
    DATE(2014,09,3)  
  ))

Forum Discussion

Create a Distinct Count of orders within a Datesbetween parameter

2 Replies

Related content

Datesbetween

count distinct

Parameter in summarize

Understanding DATESBETWEEN

DatesBetween