Forum Discussion
Pulling distinct Value based on Matching Condition
How can we pull distinct column value from one table based on matcing condition from a another column like Date
6 Replies
- Greg_Deckler
Community Champion
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.- AnonymousNot applicable
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
Super User
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
- AnonymousNot applicable
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