Unanswered

DAX Calculations in power BI

(0) Share

Report

Posted on by Kalungi A

For DAX calculations, could you please advice how I can calc a column to show number of days it takes for close an issue if I have an initial date and due date. When it approaches 5 days to the due date, the shows a red color, 15 days to due date yellow, 30 days to due date should be green

Categories:

Power Query

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report
COUNTROWS(CALENDAR([initial date],[due date]))

You can argue if you should subtract 1 or not.

When it approaches 5 days to the due date, the shows a red color, 15 days to due date yellow, 30 days to due date should be green

Please describe what you mean by "it" and "approaches".

Was this reply helpful? Yes No
Rhys @ Empower 365 4 on at

Like (0)

Report

You could you this to get the days till it's due

DaysToDue = DATEDIFF(TODAY(), [DueDate], DAY)

And then apply some conditional formatting but without a closed date you can't calculate the number of days it takes to close the issue.

Was this reply helpful? Yes No