Forum Discussion

ContabilidadBI's avatar
ContabilidadBI
Icon for Helper III rankHelper III
9 years ago
Solved

Active Clients

Hello guys,   I want to create a simple measure that calculates the number of active clients, considerating active clients, clients who bought something in the last 3 months for example. If a clien...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    HI ContabilidadBI.

     

    If these tables has relationship, you can try to use below formula to calculate the distinct count.

     

    ActiveClients = CALCULATE ( DISTINTCOUNT( Sales [ClientKey]), FILTER(ALL(Calendar),[Date]>= Date(Year(Today()),Month(Today())-3),day(today())))

    In addition, if above formula not works, I'd like to suggest you modify the 'cross filter direction' option to 'both' and try again.

     

    Regards,

    Xiaoxin Sheng

AmalrajRRD1's avatar
AmalrajRRD1
Icon for Helper II rankHelper II
9 years ago

I found the solution. Now my question is how will show only last month subtraction

for example i have five years data (2012-2017). I want to show the subtraction only between 2017 and 2016.

 

is possiable can do it .

 

Thanks

  • ContabilidadBI's avatar
    ContabilidadBI
    Icon for Helper III rankHelper III
    9 years ago

    AmalrajRRD1I answered in your own thread.

     

    Any idea guys how can I make this active clients calculation?

     

    Thanks