Forum Discussion

Helper III

1 year ago

Solved

And, DateDiff

I need to determine which Expiration Date is 30 days out and highlight it. I was trying to write the formula below and then use "1", "0" in the conditional formatting. My formula doesn't work. Can an...

FreemanZ
1 year ago
hi PC2022 ,

depending on your business logic, you need to change it to:

ApproachingDate = IF

( NOT ISBLANK (( crcc5_permitcoordination[Expiration Date] )) && DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) >=30, "red" )

Super User

1 year ago

try to apply the following measure as the conditional background color to [Expiration Date] field of your visual:

ApproachingDate = IF

( AND ( NOT ISBLANK (( [Expiration Date] )), DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) = 30, "red" )

like this:

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

Helper III

1 year ago

DAX didn't work, gave this error: too many arguements were passed to the AND function, The max argument count for the function is 2.