Forum Discussion

Qualube's avatar
Qualube
Icon for Helper II rankHelper II
7 years ago
Solved

Active Customers in Financial Year

Hi   I have been wrestling with this issue all weekend and it should be pretty straightforward however I must be missing something.   I am building a report to show total customers in any financi...
Need Help
  • Qualube's avatar
    Qualube
    7 years ago

    Hi

     

    I think I have solved it:

     

    Active Customers =
       VAR FinalActCust = CALCULATE(DISTINCTCOUNT(SALESLINE[CUSTACCOUNT]), FILTER(SALESLINE,SALESLINE[DELIVERY DATE] >=   DATE(2016,04,01) && SALESLINE[DELIVERY DATE] <= DATE(2017,03,31) && SALESLINE[DEPOT] = "UK"))
        RETURN
        FinalActCust

     

    Thanks for the help anyway

Qualube's avatar
Qualube
Icon for Helper II rankHelper II
7 years ago

Hi Thanks for the reply

 

Yes in essence I do want to find out how many customers bought in any particular financial year.

 

Appreciate the help.

Qualube's avatar
Qualube
Icon for Helper II rankHelper II
7 years ago

Hi

 

I think I have solved it:

 

Active Customers =
   VAR FinalActCust = CALCULATE(DISTINCTCOUNT(SALESLINE[CUSTACCOUNT]), FILTER(SALESLINE,SALESLINE[DELIVERY DATE] >=   DATE(2016,04,01) && SALESLINE[DELIVERY DATE] <= DATE(2017,03,31) && SALESLINE[DEPOT] = "UK"))
    RETURN
    FinalActCust

 

Thanks for the help anyway