Unanswered

DAX Calculations in power BI

(0) Share

Report

Posted on by AK-13050735-0

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 at

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,941 Super User 2025 Season 1 on at

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

Quick Links

Community site session details

DAX Calculations in power BI

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard >

Featured topics

Product updates

Community site session details

DAX Calculations in power BI

Helpful resources

News and Announcements

Quick Links

Michael Gernaey – Community Spotlight

Congratulations to the May Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard >

Featured topics

Product updates