Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

dax

p3m = var a= MAX('PSR'[Month])-2 var b =CALCULATE(DISTINCTCOUNT('PSR'[Customer_Code]),'PSR'[Month]>=a && 'PSR'[Month]<=MAX('PSR'[Month])) return b this is the formula for the above visual...
Need Help
Ahmedx's avatar
Ahmedx
Super User
2 years ago

can you share file with pivot table

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    why is this range not included in your formula?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      oh my bad you can include everything

      • Ahmedx's avatar
        Ahmedx
        Super User
        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