Forum Discussion

ppvinsights's avatar
ppvinsights
Icon for Helper III rankHelper III
6 years ago
Solved

DAX formula crashes current Power BI Desktop Version

Hi, I have a table with telephon calls logs. If have asterix verbs for "PAUSE" and "UNPAUSE". I want to calculate the pause times. The table has columns: - index (unique, ascending) - queue (type...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi ppvinsights 

     

    Please see the attached file with a solution in Power Query

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

     

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ppvinsights 

 

Try this, if still too slow we can try Power Query

PauseNextIndex = 
IF (
    FaktPascomQueueLog[verb] = "PAUSE";
    VAR curIdx = FaktPascomQueueLog[Index] 
    RETURN
    CALCULATE(
        MAX( FaktPascomQueueLog[Index] );
        ALLEXCEPT( 
            FaktPascomQueueLog; 
            FaktPascomQueueLog[agent]; FaktPascomQueueLog[queue] );
        FaktPascomQueueLog[Index] > curIdx;
        FaktPascomQueueLog[verb] = "UNPAUSE"
    );
    BLANK ()
)

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi ppvinsights 

 

Please see the attached file with a solution in Power Query

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

 

  • ppvinsights's avatar
    ppvinsights
    Icon for Helper III rankHelper III
    6 years ago

    Thanks a lot - I am little bit confused, why this calculation is to hard for Power BI... But ok 🙂

    • Mariusz's avatar
      Mariusz
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Hi ppvinsights 

       

      No problem, it is considered best practice to do your column, table transformations in Power Query, in your case the number of rows and the type of the calculation probably was hard on the engine.

       

      Best Regards,
      Mariusz

      If this post helps, then please consider Accepting it as the solution.

      Please feel free to connect with me.
      LinkedIn