Conditional formatting for most recent date

[AA622]

Hello

I have a table that lists the invoice account with multiple invoice dates. I ran a query to help pull the 'Last invoice date'. The table will pull the most recent invoice date for an account. Sometimes it'll have multiple dates for one account but only need to see the most recent one. How can I use either a measure or conditional formatting or BOTH to display the 'last invoice date'.

Heres an example of what the list will look like

Account 200017 has the last invoice date of 9/15/2021

Account 200018 has 2 of 7/19/2021 so in this case both would be highlighted. I still need to display the other dates but want the 'last invoice date' to stand out.

I am thinking of background color or icons for conditional formatting style.

Please let me know if you think a measure or how to use conditional formatting for this

[v-cgao-msft · Accepted solution]

Hi @AA622 ,

Table.

Please create a measure.

colour = 
var _value =SUM('Table'[Last Invoice Date])
return
SWITCH(
    TRUE(),
   _value =CALCULATE(MAX('Table'[Last Invoice Date]),ALLEXCEPT('Table','Table'[Invoice Account])),"red",
    BLANK()
)

Configure conditional formatting.

The result is shown below.

Attach the PBIX file for reference. Hope it helps.

Best Regards,
Community Support Team_Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

[parry2k]

@AA622 I have recently created a video on how to highlight min and max value in a matrix/table visual, in your case it will be MAX value, check this video here and tweak it as you see fit https://youtu.be/TeeKcHjA8E0

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.