Forum Discussion
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...
hi PC2022 ,
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
I changed DAX and it gave me no errors:
ApproachingDate = IF
( NOT ISBLANK (( crcc5_permitcoordination[Expiration Date] )) || DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) = 180, "red" )
But when i applied conditional formatting it highlighted all rows except for blanks