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.
Solved! Go to Solution.
Hi , @PowerBINoob24
I think the dax is right.
Switch ( True() ,
isblank(max('Execution Status'[Approved Date])) && max('Execution Status'[Due Date]) > today() , "orange" ,
max('Execution Status'[Approved Date]) >max('Execution Status'[Due Date]),"red"
)
Please confirm that your conditions are:
(1) [Approved Date]=BLANK and [Due Date]Show "orange" > TODAY()
(2) [Approved Date]> [Due Date] when showing "red"
For the conditions you give, it is not explicitly stated that [Approved Date] = BLANK() and [Due Date]<=TODAY() and so on.
For your question, you can give us some detailed example data and corresponding output sample data in tabular form so that we can better help you.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Not sure why switching the lines made a difference, but now it works.
Switch ( True() ,
max('Execution Status'[Approved Date]) >max('Execution Status'[Due Date]),"red",
isblank(max('Execution Status'[Approved Date])) && max('Execution Status'[Due Date]) < today() , "orange"
)
@PowerBINoob24 , Try like
Switch ( True() ,
isblank(max('Execution Status'[Approved Date])) && max('Execution Status'[Due Date]) > today() , "orange" ,
max('Execution Status'[Approved Date]) >max('Execution Status'[Due Date]),"red"
)
Not sure why switching the lines made a difference, but now it works.
Switch ( True() ,
max('Execution Status'[Approved Date]) >max('Execution Status'[Due Date]),"red",
isblank(max('Execution Status'[Approved Date])) && max('Execution Status'[Due Date]) < today() , "orange"
)
Unfortunately that didn't work. The cells with the approved date populated will format red, but the cells that are blank and past due do not turn orange.
Hi , @PowerBINoob24
I think the dax is right.
Switch ( True() ,
isblank(max('Execution Status'[Approved Date])) && max('Execution Status'[Due Date]) > today() , "orange" ,
max('Execution Status'[Approved Date]) >max('Execution Status'[Due Date]),"red"
)
Please confirm that your conditions are:
(1) [Approved Date]=BLANK and [Due Date]Show "orange" > TODAY()
(2) [Approved Date]> [Due Date] when showing "red"
For the conditions you give, it is not explicitly stated that [Approved Date] = BLANK() and [Due Date]<=TODAY() and so on.
For your question, you can give us some detailed example data and corresponding output sample data in tabular form so that we can better help you.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |