Forum Discussion

Topjacket's avatar
Topjacket
Helper 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
Super User
3 years ago

Topjacket, a new column

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