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
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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
    6 years ago

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

      Anonymous - I *think* you want:

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