Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Identify New Business DAX

Hi,   I am trying to identify new business between certain months this year and certain months the previous year   for example   October 2016 to September 2017 + October 2015 to September 201...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi Ashish_Mathur,

 

It seems to count the same company more than once,

 

Due to it having multiple instances of the company in the transaction table.

 

How would I go about making it distinct?

 

Thanks

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

That should not be happening.  The VALUES() function screated a unique list of all companies.  Check that there should not be any invisible charachters such as spaces before/after Company name.  If that still does not help, then share the link from where i can download the file where you are facing this problem.  Show me the exact problem in that file.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks Ashish_Mathur will do.