Forum Discussion

jtlrlfrc's avatar
jtlrlfrc
Frequent Visitor
9 years ago
Solved

Average Days between Purchases

Hi all,   I've scanned endless posts trying to find a solution to this, but the ones I've found don't quite adress what I'm looking for. For some reason this is the one thing that continues to stum...
Need Help
  • ImkeF's avatar
    ImkeF
    9 years ago

    There is no need to do this via the advanced editor, all can be done through the UI. It's just that you might be able to study the steps if you past the code as it is into the advanced editor.

    Have a look at the steps in this video:

     

jtlrlfrc's avatar
jtlrlfrc
Frequent Visitor
9 years ago

Hi ImkeF, thanks so much for your help!

 

Are you aware of any way to do this in DAX? I don't have a strong enough background to adapt this code to my dataset in the advanced editor, I'm still very much a newbie.

ImkeF's avatar
ImkeF
Community Champion
9 years ago

There is no need to do this via the advanced editor, all can be done through the UI. It's just that you might be able to study the steps if you past the code as it is into the advanced editor.

Have a look at the steps in this video:

 

  • jtlrlfrc's avatar
    jtlrlfrc
    Frequent Visitor
    9 years ago

    Hi Imke, that worked like a charm! In hindsight I made it much more complicated than it had to be, but I've been fiddling with PowerBI only a few days. Thanks so much for taking the time to explain it, I learned a little more today :)