Forum Discussion

kyleldi's avatar
kyleldi
Frequent Visitor
9 years ago

Counting data between two date ranges

I have a delivery table that contains a date column and a status column.  I'm looking to graph that data by status by month and rolling week.  The data appears correctly on the Data Detail table I ma...
Need Help
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi kyleldi

 

What is the code you have used to create your OTD table?

  • kyleldi's avatar
    kyleldi
    Frequent Visitor
    9 years ago

    Phil_Seamark Here's my code for the OTD table.

     

    OTD = DISTINCT('vw_PBI-OnTimeDelivery'[Shipped_Date (bins)])
    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi kyleldi,

       

      If you want to get the distinct count of selected date range, you can try to use below formula:

      Count of Selected DateRange= 
var selectedMin=FIRSTDATE(ALLSELECTED('Table'[Date]))
var selectedMax=LASTDATE(ALLSELECTED('Table'[Date]))
return
CALCULATE(DISTINCTCOUNT('vw_PBI-OnTimeDelivery'[Shipped_Date (bins)]),FILTER(ALL('Table'),[Date]>=selectedMin&&[Date]<=selectedMax))

       

      Notice: table is the source table of the date slicer.

       

      Regards,

      Xiaoxin Sheng