I have this table :
I want to make a conditional formatting on value like this :
Is there any way to do this with conditional formatting?
Go to Solution.
@Fragan , You can use time intelligence and date table for This Month Vs last month
MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))last MTD (complete) Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(ENDOFMONTH(dateadd('Date'[Date],-1,MONTH))))
Use color grouping on Diff
Or create a color measure and use it with "Field" option in color grouping
Color sales = if([Sales MTD] -[sales LMTD]>0,"green","red")
Proud to be a Super User!
View solution in original post
Check out the News & Announcements to learn more.
Congratulations, the new Super User Season 2 for 2021 has started!
Check out the new Power Platform Community Connections gallery!