Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
2 years ago

Calculation New, Repeat Customer

Hi BI Community Team,   I have a sales order table (Aug'23 till Oct'23), with this I have created a measure below to find the customer purchased:   Customer Purchased = CALCULATE(DISTINCTCOUNT('...
Need Help
ADSL's avatar
ADSL
Post Prodigy
2 years ago

Hi Ashish_Mathur,

 

Just feedback what I see however still need your support and advise. sometimes we misunderstand or wrong explain then result also are different.

 

Thanks and Regards,

Ashish_Mathur's avatar
Ashish_Mathur
Super User
2 years ago

I really do not know how ealse to help you.  Create a small dataset and try my formulas on that small dataset.  See if you get the perfect result there or not.  If there is a problem even on that small dataset, then we will revise the formula.  Finally we will then plug in your large dataset.  Please send time on doing this checking yourself.

  • ADSL's avatar
    ADSL
    Post Prodigy
    2 years ago

    Hi Ashish_Mathur ,

     

    Well noted. Thank you very much for your value time and help.

     

    Best Regards,