Forum Discussion

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

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

Community Champion

6 years ago

Anonymous - I *think* you want:

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