DATES BETWEEN

[chilton]

Hi, 

I am new to Power Bi and attempting to learn how to calculate DATESBETWEEN (Status Not Started and Status Completed/Denied). 

I feel completely lost.  Can anyone help? 

[v-yinliw-msft · Accepted solution]

Hi @chilton ,

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.