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
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,