topic Re: Pulling distinct Value based on Matching Condition in DAX Commands and Tips

Pulling distinct Value based on Matching Condition

Anonymous — Sun, 06 Sep 2020 17:30:51 GMT

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

Re: Pulling distinct Value based on Matching Condition

Greg_Deckler — Sun, 06 Sep 2020 17:56:32 GMT

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.

Re: Pulling distinct Value based on Matching Condition

Anonymous — Sun, 06 Sep 2020 19:22:12 GMT

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 .

Re: Pulling distinct Value based on Matching Condition

amitchandak — Mon, 07 Sep 2020 01:39:54 GMT

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

Re: Pulling distinct Value based on Matching Condition

Anonymous — Mon, 07 Sep 2020 13:31:30 GMT

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

Re: Pulling distinct Value based on Matching Condition

Anonymous — Mon, 07 Sep 2020 17:57:15 GMT

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

Re: Pulling distinct Value based on Matching Condition

Greg_Deckler — Mon, 07 Sep 2020 18:09:26 GMT

Anonymous - I *think* you want:

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