Hi,
I have just started with power pivot for the analysis of the company data.
I have written a measure to detect new customers.
the measure is:
=CALCULATE(
COUNTROWS(Klant_Groepen),
FILTER(Klant_Groepen,
CALCULATE(COUNTROWS(Dossier))>0&&
CALCULATE(COUNTROWS(Dossier),FILTER(ALL(Table_Calendar),Table_Calendar[Date] < MIN(Table_Calendar[Date])))=0))
and
=CALCULATE([Turnover],
FILTER(Klant_Groepen,
CALCULATE(COUNTROWS(Dossier))>0&&
CALCULATE(COUNTROWS(Dossier),FILTER(ALL(Table_Calendar),Table_Calendar[Date] < MIN(Table_Calendar[Date])))=0))
I also wanted to make a calculated column so that I can also use new and existing customers as a filter.
This is something I cannot figer out.
Can someone help me?
Thanks in advance.
I have just started with power pivot for the analysis of the company data.
I have written a measure to detect new customers.
the measure is:
=CALCULATE(
COUNTROWS(Klant_Groepen),
FILTER(Klant_Groepen,
CALCULATE(COUNTROWS(Dossier))>0&&
CALCULATE(COUNTROWS(Dossier),FILTER(ALL(Table_Calendar),Table_Calendar[Date] < MIN(Table_Calendar[Date])))=0))
and
=CALCULATE([Turnover],
FILTER(Klant_Groepen,
CALCULATE(COUNTROWS(Dossier))>0&&
CALCULATE(COUNTROWS(Dossier),FILTER(ALL(Table_Calendar),Table_Calendar[Date] < MIN(Table_Calendar[Date])))=0))
I also wanted to make a calculated column so that I can also use new and existing customers as a filter.
This is something I cannot figer out.
Can someone help me?
Thanks in advance.