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.
Hello All
I have these two DAX measures. I basically need to color one column two different colors (Red if date in other column is within 45 days and Yellow if within 60 days. I will need the 45 day rule to have higher precedent so that it overrides the 60 day Yellow when the appropriate time comes.
Does anyone know how to nest these two statements together and give the 45 day higher precedent?
45_Day_Color = if(FIRSTNONBLANK(Elig_List[45_Day_Alert],TODAY()) <today(),"red","white")
60_Day_Color = if(FIRSTNONBLANK(Elig_List[60_Day_Alert],TODAY()) <today(),"yellow","white")
I appreciate any help!
Solved! Go to Solution.
Hi @Userpath77 ,
I believe SWITCH would help here.
MEASURE =
SWITCH(
TRUE(),
SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<45,
"RED",
SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<60,
"YELLOW",
"WHITE"
)
Hi @Userpath77 ,
I believe SWITCH would help here.
MEASURE =
SWITCH(
TRUE(),
SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<45,
"RED",
SELECTEDVALUE('Table'[ColumnWithDate])-TODAY()<60,
"YELLOW",
"WHITE"
)
Thanks Payeras-----I had to adjust it a little, but worked perfect! Thanks again.
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 |
---|---|
42 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |