Forum Discussion

JChouris's avatar
JChouris
Helper I
4 years ago
Solved

Time Study

I am very new to Power BI and a bit stuck on this one. I am doing a time study and need to multiply the skill and effort of each Procedure by the amount of seconds it takes, I need an individual total score for each step, then a grand totlat of the Skill and Effort Fields. I keep getting these crazy high numbers because it is using the total seconds and total skill/effort. Any help would be greatly appreciated. Thank you.

 

 

3 Replies

  • JChouris 

    Try it like this.

    Total Score = SUMX ( YourTable, YourTable[Seconds] * YourTable[Skill] )

     

    • JChouris's avatar
      JChouris
      Helper I

      Worked like a charm. Thank you for you assistance.

  • My cousin's brother wants to study abroad just because of this I shared this post with my brother. He asked me why are you send this to me, I said brother you just read it once you get good information from here. When I close this page I got this https://www.biologysap.com/ site details. I already read somewhere about this site. This one site is almost every student uses it just because of this quality.