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
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.

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

      Hi,

       

      I do not understand the problem.  Please be specific where the problem is and also show me your expected result.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Hi,

         

        I am wanting to create a summarized table showing 

         

        Number of New Business    Number of interactions    Revenue

         

        Then a table showing

         

        Number of Business That spent this Year and Last Year    Number of interactions    Revenue

         

        and

         

        Number of Lost Businesses    Number of interactions    Revenue

         

        using the title slicer and month slicer.

         

        Thanks