Forum Discussion

SidharthK16's avatar
SidharthK16
Frequent Visitor
3 years ago

Lookupvalue within same column

Hi All, I have a table listing Respondent Id's and Brand. 2nd table with time period as months . I want to check the Repeat Rate of Respondent Id's with different Months(Like if in April we ha...
Need Help
Show and Tell
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

SidharthK16 Use INTERSECT.

Measure =
  VAR __April = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Month] = "April"),"__ID",[Respondent Id]))
  VAR __May = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Month] = "May"),"__ID",[Respondent Id]))
RETURN
  CONCATENATEX(INTERSECT(__May, __April),[__ID],",")
  • SidharthK16's avatar
    SidharthK16
    Frequent Visitor
    3 years ago

    Thanks Greg for you solution.
    But this is not working for me .

    VAR __April = DISTINCT(SELECTCOLUMNS(FILTER('Table',[Month] = "April"),"__ID",[Respondent Id]))

    I don't want my month to fixed, user can select any month as per their need like June , July and also The respondent Id are in a column but here we have to add the measure at the end.