Average Days Between Orders

DAX DAX Calculations
5

@MAAbdullah47 Data in your PBI files ends on 12/30/2017 :frowning:

1 Like
6

@AntrikshSharma spot on :+1:

1 Like
7

Actually I give this as an example not from my data.

8

I’ll check.

9

Hi @MAAbdullah47, did the response provided by the experts help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

10

I have small problem @MudassirAli , I want to create Index through power query but The data I have is too big (2.5M) rows, Always crash out of memory, do you have an Idea how to create the Index through (DAX) based on date Instead of Power Query?

11

@AntrikshSharma @MudassirAli I meant create a column not measure.

12

@MAAbdullah47 If PQ can’t do it, I am sure DAX can’t handle it as well, you will have to do it at the data source. But why add index to 2.5 M rows?

13

Hi @AntrikshSharma
because the solution require this , please re-check it.

14

If I do it from the Source file, It is csv when you open it through excel it will shrinking
did you got it?

15

@MAAbdullah47 Doing indexing is not a problem outside PBI, I can do it with VBA and Python, but the point you should ask yourself is if you really need indexing? it will increase the size of your model. What is the goal that you want to achieve with index?

16

I want to solve the problem of Days Between Orders to be dynamic, you posted solution before but it doesn’t work dynamically, @MudassirAli post one works fine with small db (Creating index) but with the cussrent db it doesn’t work , did you got it @AntrikshSharma?

17

Hi Experts again

Please check the example below:

Customer X

I need to calculate the difference between each order (n) and Order (n+1) how many days?

then from Order (n+1) to Order (n+2) How many days?

…etc

Customer X+1

I need to calculate the difference between each order (n) and Order (n+1) how many days?

then from Order (n+1) to Order (n+2) How many days?

…etc

Then I need the (Average Days) Between Orders for all customers is the question clear?

18

@MAAbdullah47 The current and this post

are these same?

19

Hi @AntrikshSharma

Yes But now I encountered wrong results.

20

@AntrikshSharma, @MAAbdullah47,

I think we should merge these two threads together, since they seem to be addressing basically the same question.

Re: my earlier solution, we can rework that without the index. I use it because I think it adds clarity to the solution, but it’s not necessary.

@AntrikshSharma - how do you want to proceed?

  • Brian
21

Ok I’ll merge it, but need assitance from the Admin @EnterpriseDNA how to merge it.

22

@MAAbdullah47,

We’ll take care of that. I’m reworking my prior solution for you and should have something back to you later today.

  • Brian
23

@MAAbdullah47,

I’ve provided you a revised solution here:

Please let me know if this meets your needs. If necessary, we can continue the discussion in that thread, and I will close this one out.

  • Brian
2 Likes