Forum Discussion
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...
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
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"))