Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Count Cases based on Days between Dates

Trying to figure out the best way to do this.   I want to create a measure wheere I can Distinct Count cases where the FIRST Date of Request to Recieved Date is 15 days or less, as we can request i...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    Anonymous 

    you can try to create a new column

    Column = if('Table'[request date]=CALCULATE(min('Table'[request date]),ALLEXCEPT('Table','Table'[case id]))&&'Table'[Days Difference]<=15,1,0)

     

    then you sum up the new column and you will get 2

  • Ahmedx's avatar
    Ahmedx
    2 years ago

    Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.