Forum Discussion
Conditional Formatting Workaround for Dates
Hi - I currently have a table that is aggregated by date in the columns and a text label as the rows. I have another table (Deals and Coupons) that has those same text labels and returns deal dates a...
Hello, below I've included an example of what is curretly happening vs desired result. The current result is using this MAX() formula = if(and(SELECTEDVALUE('Calendar'[Date])>=MAX('Deals and Coupons'[Coupon Start Date]),SELECTEDVALUE('Calendar'[Date])<=MAX('Deals and Coupons'[Coupon End Date])),"#A9F099". I would like the formula to return true at every instance of a date match within range.