Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity 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.

    • Anonymous's avatar
      Anonymous
      Not 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 . 

    • Anonymous's avatar
      Anonymous
      Not applicable

      Greg_Deckler sharing the sample data

       

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

       

      VM NameLatest_VM
      05c58dc681cd4b3f98c06a59c58bcafeLatest
      AAENL00020-adgLatest
      AAENW00050NPM01Latest
      AAENW00050NPM02Latest
      AAENW00077BICTLatest
      AAENW00147AAFLatest
      AAENW00147AASLatest
      AAENW00147SCPLatest
      AAENW00169-latLatest
      AAEPW00043PBT01Latest
      AAEPW00043PST01Latest
      AAEPW00049NPM01Latest
      AAEPW00049NPM02Latest
      AAEPW00282AUSP1Latest
      AASNW00050NPM01Latest
      AASNW00050NPM02Latest
      AASNW00137POCLatest
      AASNW00137POC1Latest
      AASNW00137-testLatest
      AASNW00138POCLatest
      AASNW00376PEXIPLatest
      a9553c34e4b748ff99c521b82dae8151Old
      a95dd5f9832144cea2f57450f96b47dbOld
      aa7b472cd5a74c42a018cc07aa7d67d1Old
      AAENL00018TVM1Old
      AAENL00018TVM2Old
      AAENL00018TVM3Old
      AAENL00019TVM1Old
      AAENL00020-adgOld
      AAENL00100-LIN2Old
      AAENW00019TVM1Old
      AAENW00050NPM01Old
      AAENW00050NPM02Old
      AAENW00077BICTOld
      AAENW00147AAFOld
      AAENW00147AASOld
      AAENW00147SCPOld