Forum Discussion

Sedos101's avatar
Sedos101
Helper I
3 years ago
Solved

Grouping

Hi Everyone   I am trying to group a set of rows based on reocurring row values.   Essentially I have a Haul Truck that I want to define each cycle it does from its haul cycle state. The start...
Need Help
Sedos101's avatar
Sedos101
Helper I
3 years ago

HI Greg_Deckler 

 

Thanks very much for your help, I am getting a "There's not enough memory to complete this operation"

 

I tried increasing my memory settings in Power BI but to no luck.

 

Is there a way to do it in Power Query instead of a DAX measure?

 

Thanks again

Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

Sedos101 I personally have no earthly clue regarding how to implement a Cthulhu-esque calculation in Power Query. But, hopefully ImkeF or edhans do.

  • Sedos101's avatar
    Sedos101
    Helper I
    3 years ago

    Hi Greg_Deckler 

     

    Thanks again for your help, would you happen to know how I could get around the Memory Issue error?

     

     

    • Sedos101's avatar
      Sedos101
      Helper I
      3 years ago

      Hi Greg_Deckler 

       

      I got it to work, by reducing my data

       

      However it does not seem to work if there is more that one loading row in a cycle? 

       

      It seems to just start back at number 1 for the next cycle...

       

      Thanks

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion
        3 years ago

        Sedos101 Yeah, tough problem to solve, the data is uh...uh...uh...ugly. Shoot me some sample data that replicates that specific issue and I can see what I can come up with. But, additional calculations are probably going to slow things down even more.