Unanswered

DAX Calculations in power BI

Like (0) Share

Report

Posted on 13 May 2025 07:41:47 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:

General Comment

All responses (2)

Answers (0)

Rhys @ Empower 365 4 on 14 May 2025 at 10:31:47

Like (0)

Report

DAX Calculations in power BI

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.
lbendlin 7,956 Super User 2025 Season 1 on 13 May 2025 at 13:26:15

Like (0)

Report
DAX Calculations in power BI

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".