DATES BETWEEN

Hi Anonymous ,

 

You can try this method:

Sample data:

Because the function Datesbetween return a table which has a single column, so you should create a table:

NotStartedBetweenDenied = 
var _Den = CALCULATE(MAX('Table'[Date]), FILTER('Table','Table'[Status] = "Denied"))
var _NOTS = CALCULATE(MIN('Table'[Date]), FILTER('Table','Table'[Status] = "Not Started"))
return
DATESBETWEEN('Table'[Date], _NOTS, _Den)

NotStartedBetweenCompleted = 
var _Com = CALCULATE(MAX('Table'[Date]), FILTER('Table','Table'[Status] = "Completed"))
var _NOTS = CALCULATE(MIN('Table'[Date]), FILTER('Table','Table'[Status] = "Not Started"))
return
DATESBETWEEN('Table'[Date], _NOTS, _Com)

The result is:

For more information about this function, you can refer this method:

DATESBETWEEN function (DAX) - DAX | Microsoft Learn

 

Hope this helps you.

Here is my PBIX file.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.