Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
JChouris
Helper I
Helper I

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.

 

JChouris_0-1654532944881.png

 

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@JChouris 

Try it like this.

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

 

View solution in original post

3 REPLIES 3
scottsk91
New Member

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.

jdbuchanan71
Super User
Super User

@JChouris 

Try it like this.

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

 

Worked like a charm. Thank you for you assistance.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.