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
SidharthK16's avatar
SidharthK16
Frequent Visitor
3 years ago

Thanks for solution!

But what if I have Multiple months like Jan, Feb ,March, April, May etc.
And I have to check Repeat rates for Jan and March

 

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi SidharthK16 ,

Do you mean for each month, you need to check all the previous months? eg for May, need to check repeat with Jan, Feb ,March, April seperately?
Best Regards,
Community Support Team _ kalyj

  • SidharthK16's avatar
    SidharthK16
    Frequent Visitor
    3 years ago

    No no
    Just for two months
    Like what all are in Jan are reapeated in March.

     

    • v-yanjiang-msft's avatar
      v-yanjiang-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi SidharthK16 ,

      What's the logic which two months are compared, if you don't want the formula to be fixed.

      Best Regards,
      Community Support Team _ kalyj

      • SidharthK16's avatar
        SidharthK16
        Frequent Visitor
        3 years ago

        I have two different slicers for time period