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

Now I want to find latest month, latest quarter and Latest year differences value.

 

How will do it ?

 

Thanks.

 

 

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

Bro, don't you have your own thread where me and others answered you? don't want to be rude but lets keep an order please.

 

Thanks.