Calculating Non First Order Of the customer

[MAAbdullah_47]

Dear Experts

Please refer to this topic tutorial link: https://towardsdatascience.com/explore-the-potential-of-products-through-customers-purchase-behaviou...

Please refer to this topic tutorial link: https://towardsdatascience.com/explore-the-potential-of-products-through-customers-purchase-behaviou...

My question is regard the calculated column (IsFirstorder) as it said in the page :
" First, classify all orders for the sales table, in all orders of the customer, one or more orders with the earliest order date are classified as the first order, the rest are “non-first”:" , when I implemented it on my showcase it gives me (out of memory problem) this happen when I call the measure (CustPurchaseOthersSubcategoryAfter ) as on this image:

because the table I’m using it is above 10M rows not like the one used on the (Page tutorial) , Is there any alternatives such as :
1- Using custom column in Query editor?
Or
2-Using measure ,
or any other suggestion to avoid the out of memory and/or bad performance ?

[Greg_Deckler]

@MAAbdullah_47 What is the measure formula you are using?

[MAAbdullah_47]

Hi , I think the problem on the calculated column , IsFirstOrder 

[Greg_Deckler]

@MAAbdullah_47 Not sure about that. Calculated column shouldn't generate DAX queries since it is already calculated at the time of creation or refresh so it shouldn't be the issue you are seeing, more likely an issue with the measure: CustPurchaseOthersSubcategoryAfter

[MAAbdullah_47]

Hi @Greg_Deckler 
When I try to install the Tool 

I need to save it how I can save it as (JSON) file , the option is only as a text , please check the screen-shot: 

"path": "E:\\MSHGQM_Gamma\\MicrosoftHatesGregsQuickMeasures\\MicrosoftHatesGregsQuickmeasures.exe",

☝️☝️

One more question: Is this correct text for witing the path?

[Greg_Deckler]

@MAAbdullah_47 Yes, that is the correct syntax for the path, you have to use double backslash because it is a JSON file and you have to escape backslash characters so a \\ ends up being a single \.

You should be able to use the drop down for the Save As dialog and choose All files. Then it will write the file as a .json file and not tag .txt onto the end as an extension.

[MAAbdullah_47]

Still didn't been solved , @Greg_Deckler gives me generic answer , I need to find and do by my own.