Forum Discussion

Topjacket's avatar
Topjacket
Icon for Helper I rankHelper I
3 years ago
Solved

Check if customer reference contains full data.

Hi   I am hoping this will be easy but I can't get it to work. I am trying to add a column (so I can filter certain records from output) which counts the distinct number of "Month & Year" in the en...
  • amitchandak's avatar
    amitchandak
    3 years ago

    Topjacket , Sorry my bad, used , inplace of =

     

    if(distinctcount(Table[Month Year])= calculate(distinctcount(Table[Month Year]),filter(Table, Table[Customer]= earlier(Table[Customer]))) , "Yes", "No")

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

Topjacket , Sorry my bad, used , inplace of =

 

if(distinctcount(Table[Month Year])= calculate(distinctcount(Table[Month Year]),filter(Table, Table[Customer]= earlier(Table[Customer]))) , "Yes", "No")

Topjacket's avatar
Topjacket
Icon for Helper I rankHelper I
3 years ago

Thanks very much amitchandak 

 

I thought I had tried different combos but I obviously missed this one. All working great now.

 

Thanks again.