FIltering specific values across multiple rows

[Anonymous]

I have a table of customers and different invoices raised, sometimes for the same customer

I want a table to show me the latest update for each invoice

i used the below calculated column however, it is now pulling the latest status update for all duplicated customers even if each invoice is at a different stage

is there a way to show the status for each individual invoice for each customer rather than grouping all customers together and showing the latest status update??

[Anonymous]

Hi @selimovd worked exactly as i had hoped

i had been trying to figure this out in another post i had up, just by chance i came across the part solution and you have helped complete it

am i able to tag this answer into my other post?

thank you again!! 😀

[selimovd]

Hey @Anonymous ,

I'm happy that worked.
Usually you can just mark a post from the current thread as a solution. But I can also write a summary in the other post if you send me the link.

Anyway I'm happy you could solve that 🙂

Best regards

Denis 

[Anonymous]

Hi @selimovd 

link below

Re: how do i auto populate columns with specific d... - Microsoft Power BI Community

[selimovd · Accepted solution]

Hello @Anonymous ,

can you paste here the table or a few lines with the relevant columns?

This makes it easier to analyze the issue.

I also don't see the column [Project Title] in the screenshot, so it's hard to analyze the problem. Probably the context transition doesn't work. Did you try to put a CALCULATE around the MAXX statement?

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi