Forum Discussion
Matrix table with colour rules
Hello Team,
I need to create a matrix table where it indicates the latest files received and if it has been transfered successfully in the database.
Here is my raw data:
| Site | Date | Worksheet | Status |
| ABC | 26/01/2024 | rdept | Completed |
| CDE | 25/01/2024 | gpm | Completed |
| ACB | 26/01/2024 | rdept | Error |
I need to create a measure that indicates in red that we didn't receive the latest gpm file for site CDE and that the latest file of ACB has errors. If the the latest file is today and the status is completed, the cell should be highlighted in Green in my matric table.
Any idea how i can do this?
Many Thanks and Kind Regards,
chiran
Create this measure:CF Color = VAR __CurrentDate = TODAY() VAR __Date = SELECTEDVALUE( Table41[Date] ) VAR __Status = SELECTEDVALUE(Table41[Status]) VAR __Result = IF( __Date < __CurrentDate || __Status = "Error" , "red" , "green" ) RETURN __ResultSelect Status from the series drop down and click on fx
Assign the mesure as Field Value
2 Replies
chiran
Create this measure:CF Color = VAR __CurrentDate = TODAY() VAR __Date = SELECTEDVALUE( Table41[Date] ) VAR __Status = SELECTEDVALUE(Table41[Status]) VAR __Result = IF( __Date < __CurrentDate || __Status = "Error" , "red" , "green" ) RETURN __ResultSelect Status from the series drop down and click on fx
Assign the mesure as Field Value
Hi chiran ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
