Pulling distinct Value based on Matching Condition

[Anonymous]

How can we pull distinct column value from one table based on matcing condition from a another column like Date

[Greg_Deckler]

@Anonymous - Well, there is LOOKUPVALUE or MAXX(FILTER(...)...). Might have to use DISTINCT but way to vague of a question to answer with any certainty. 

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[Anonymous]

@Greg_Deckler sharing the sample data

I want to pick Distinct value on VM Name in new table where Latest_VM = Latest

VM Name	Latest_VM
05c58dc681cd4b3f98c06a59c58bcafe	Latest
AAENL00020-adg	Latest
AAENW00050NPM01	Latest
AAENW00050NPM02	Latest
AAENW00077BICT	Latest
AAENW00147AAF	Latest
AAENW00147AAS	Latest
AAENW00147SCP	Latest
AAENW00169-lat	Latest
AAEPW00043PBT01	Latest
AAEPW00043PST01	Latest
AAEPW00049NPM01	Latest
AAEPW00049NPM02	Latest
AAEPW00282AUSP1	Latest
AASNW00050NPM01	Latest
AASNW00050NPM02	Latest
AASNW00137POC	Latest
AASNW00137POC1	Latest
AASNW00137-test	Latest
AASNW00138POC	Latest
AASNW00376PEXIP	Latest
a9553c34e4b748ff99c521b82dae8151	Old
a95dd5f9832144cea2f57450f96b47db	Old
aa7b472cd5a74c42a018cc07aa7d67d1	Old
AAENL00018TVM1	Old
AAENL00018TVM2	Old
AAENL00018TVM3	Old
AAENL00019TVM1	Old
AAENL00020-adg	Old
AAENL00100-LIN2	Old
AAENW00019TVM1	Old
AAENW00050NPM01	Old
AAENW00050NPM02	Old
AAENW00077BICT	Old
AAENW00147AAF	Old
AAENW00147AAS	Old
AAENW00147SCP	Old

[Anonymous]

@Greg_Deckler thanks for the response 

I want to pick unique user name where date = 'latest'

The table has a username column and date columns which has old and latest values .I want to unique from the columns where date is latest . 

[amitchandak]

@Anonymous ,

lastestnonblankvalue(Table[date],max(Table[UseNAme]))

Refer

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

[Anonymous]

@amitchandak  will this be creating a new table  ? I have pasted the sample data on the previous comments and the desired output. 

Please suggest 

@Greg_Deckler 

[Greg_Deckler]

@Anonymous - I *think* you want:

New Table = 
  DISTINCT(
    SELECTCOLUMNS(
      FILTER('Table',[Latest_VM]="Latest"),
      "VM Name",[VM Name]
    )
  )