Forum Discussion

UlliJ's avatar
UlliJ
New Member
9 years ago

Conditional average

I am quite new to powerBI and I feel like I have tried everything to solve this.  The table below indicates time spent producing an order (Behandlingstid = total working days). As you can see every ...
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
9 years ago

Hi UlliJ

 

So do you want to sum up the Behandlingstid for each row per order.  And then work out the average across all orders?  Or are you after an an average of the rows within the order?

  • UlliJ's avatar
    UlliJ
    New Member
    9 years ago

    Hi Phil_Seamark

     

    Thank you for your fast response.

     

    I want the average pr order so I can calculate the average for all orders, not just the average per row. Does that make sense?

    • Phil_Seamark's avatar
      Phil_Seamark
      Microsoft Employee
      9 years ago

      Can you please cut/paste some sample data to save having to type it into a local copy of PBIX :)

      • UlliJ's avatar
        UlliJ
        New Member
        9 years ago

        This is how new I am to this that I am not quite sure what you mean, but reading your question again it is the latter part I want. "Or are you after an an average of the rows within the order?"

         

        Ulrikke