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")

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

Hi Both

 

Thanks very much for the replies.

 

amitchandak I did try this dax but was getting an error message saying there were too many paramaters. Any ideas?

 

v-yueyunzh-msft I tried this formula and it did not error but also it set all records to "Yes" which is not correct.

 

I have placed an example table below with the desired output (Full Data Set?). Customer ABC is returning "No" because the entire data set has 4 months of data but customer ABC only has 3 months.

 

Any advice you can offer would be great.

 

Thanks again

 

CustomerIDMonthAndYear

FullDataSet?

1

Jan 2020

Yes
1Feb 2020Yes
1Mar 2020Yes
1Apr 2020Yes
ABC Jan 2020No
ABCFeb 2020No
ABCMar 2020No
ABC123 Jan 2020Yes
ABC123Feb 2020Yes
ABC123Mar 2020Yes
ABC123Apr 2020Yes

 

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.