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,

 

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 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    With the true company and new business in the same table it says new business is 166, however if you remove the true company field it says there are  1003

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Something like

     

     

    Table 6 = SUMMARIZE(Query1,Query1[TrueCompany],"New Business",CALCULATE(COUNTROWS(Query1),FILTER(VALUES(Query1[TrueCompany]),[Date of first interaction with Company]>=MIN('Calendar$'[Date])),Query1[ttlname] = "Barrow Advertiser"),"Number of Weeks",CALCULATE(DISTINCTCOUNT(Query1[FinWeek of Year]),FILTER(VALUES(Query1[TrueCompany]),[Date of first interaction with Company]>=MIN('Calendar$'[Date])),Query1[ttlname] = "Barrow Advertiser"))