Forum Discussion
Syndicate_Admin
Administrator
AdministratorDax
p1m = CALCULAR( DISTINCTCOUNT(PSR[customer_code]), FILTRO( VALORES(PSR[customer_code]), [suma de ret] > 0 ) ) Se trata de una medida que calcula el número de cl...
Syndicate_AdminAdministrator
AdministratorPor favor, pruebe esto
CURRENT MONTH =
VAR _Start = EOMONTH(TODAY(),-1)+1
VAR _End = EOMONTH(TODAY(),0)
RETURN
CALCULATE([p1m], DATESBETWEEN('Calendar'[Date],_Start,_End)
-------------
Last 1 MONTH =
VAR _Start = EOMONTH(TODAY(),-2)+1
VAR _End = EOMONTH(TODAY(),-1)
RETURN
CALCULATE([p1m], DATESBETWEEN('Calendar'[Date],_Start,_End)
------------
Last 2 MONTH =
VAR _Start = EOMONTH(TODAY(),-3)+1
VAR _End = EOMONTH(TODAY(),-2)
RETURN
CALCULATE([p1m], DATESBETWEEN('Calendar'[Date],_Start,_End)