Forum Discussion
Querying between two dates
Hi Neiltc
There is a solution to do it in Power BI, if you wnat to do it in excel, you need to post on excel forum.
I assume that projects that were not completed on time are which fulfilled date is larger than due date.
Also “each month” is determined by due date.
So I can create calculated columns
month = MONTH([due date])
complete = IF([fullfilled date]<=[due date],1,0)
percentage of not completed per month =
CALCULATE (
COUNT ( Sheet1[complete] ),
FILTER ( ALLEXCEPT ( Sheet1, Sheet1[month] ), [complete] = 0 )
)
/ CALCULATE ( COUNT ( Sheet1[complete] ), ALLEXCEPT ( Sheet1, Sheet1[month] ) )Best Regards
Maggie
Maggie, I am actually trying to do this in BI but thought it would be easier through Excel. The goal is to see in each month the percentage of projects that were not completed on time. is there a PowerBI solution for this?
Thank you
Hi Neiltc
There is a solution to do it in Power BI, if you wnat to do it in excel, you need to post on excel forum.
I assume that projects that were not completed on time are which fulfilled date is larger than due date.
Also “each month” is determined by due date.
So I can create calculated columns
month = MONTH([due date])
complete = IF([fullfilled date]<=[due date],1,0)
percentage of not completed per month =
CALCULATE (
COUNT ( Sheet1[complete] ),
FILTER ( ALLEXCEPT ( Sheet1, Sheet1[month] ), [complete] = 0 )
)
/ CALCULATE ( COUNT ( Sheet1[complete] ), ALLEXCEPT ( Sheet1, Sheet1[month] ) )
Best Regards
Maggie