Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 according to which items we had on a deal and when. I would like for this formula to return the conditional formatting for every deal that occured in the table, but I have only made it able to work by taking the max aka last deal date in the list. Any ideas how to get around this?
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.
Please provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
94 | |
80 | |
71 | |
64 |
User | Count |
---|---|
115 | |
106 | |
96 | |
81 | |
72 |