Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
How can we pull distinct column value from one table based on matcing condition from a another column like Date
@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.
@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 |
@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 .
@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
@amitchandak will this be creating a new table ? I have pasted the sample data on the previous comments and the desired output.
Please suggest
@Anonymous - I *think* you want:
New Table =
DISTINCT(
SELECTCOLUMNS(
FILTER('Table',[Latest_VM]="Latest"),
"VM Name",[VM Name]
)
)
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
86 | |
84 | |
52 | |
37 | |
23 |