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 anyone help please?
ApproachingDate = IF
(( AND ( NOT ISBLANK (( [Expiration Date] )), DATEDIFF (TODAY (),crcc5_permitcoordination[Expiration Date], DAY ) = 30, "1", "0" ))
5 Replies
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
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.
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
