Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Dax

Esto es count cal cuando se incluye -ve retailing. p3m = Dónde a= ..MAX('PSR'[Mes])-2 Dónde b =CALCULAR(DISTINCTCOUNT('PSR'[Customer_Code]),'PSR'[Mes]>=a && 'PSR'[Mes]<=..MAX('PSR'[Mes])) de...
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Measure 2 = 
var a= MAX('PSR'[Month])-2
var b =CALCULATE(DISTINCTCOUNT('PSR'[Customer_Code]),'PSR'[Month]>=a && 'PSR'[Month]<=MAX('PSR'[Month])&& 'PSR'[sale]>0)
return
b