Outstanding Projects

[Anonymous]

Hi, I've been trying to figure out how to calculate the outstanding projects on power bi by using the dataset listed below. This dataset seen below is from excel with the calculation on how to get the outstanding projects. I want to try use a similiar formula to the one used in excel. 

Please help ASAP.

[amitchandak]

@Anonymous , You have create an independent date table for slicer

then you can have measures like

Sumx(Table, Datediff([completion Date], selectedvalue([Date], today()) , day) +1)