Hello
I want to:
a. calculate the case age between two dates (created on Date and Completed On date), if the status = Close or Resolved or Cancelled Or
b. Calculate the case age between two dates (created On and Today), if the status = Active
in Power BI, with the exclusion of holidays and Weekends.
Please note that I have a table which i have created a calendar table where I have specified the workdays and holidays and weekends. See screen shot below.
Specifically, can someone please help me with the formula to calculate the Case Age in Power BI?
this query gives me error, can someone help me correct it
Age = IF(Intakes[value.statecode@OData.Community.Display.V1.FormattedValue]=/Active/,
IF(CALENDAR([Work Hours]>0,
DATEDIFF(Intakes[value.createdon@OData.Community.Display.V1.FormattedValue],TODAY(),DAY))
THANK YOU IN ADVANCE
Share
Report
All responses (
Answers (
170
