Beyond Boundaries: IPL

Logeshkumar S Avatar

Logeshkumar S

Lumel Technologies

Power BI Dashboard

Additional project images

Logeshkumar S Avatar

Logeshkumar SLumel Technologies

More projects by Logeshkumar

Find Your Dream Home in Bangladesh

Keeping You Connected

0 Likes

0 Comments

Discussion and feedback(3 comments)

comment-1416-avatar

Shubham Khandekar

6 months ago

Hi Logesh, I loved your dashboard and i was in the process creating a similar dashboard. However i couldn't identify how can i display score and overs the way you have done over here. Would love to get your feedback on your thought process behind the calculations.

comment-1432-avatar

Logeshkumar S

Project owner

6 months ago

Project owner

Hi Shubham. Thank you so much! I'm glad you liked it. I have included DAX below. Kindly refer and let me know if u have any queries. Over = IF(MOD(MAX(Inns_1[Ball]),1)>=0.6,ROUND(MAX(Inns_1[Ball]),0),MAX(Inns_1[Ball])) Score = CONCATENATE(FORMAT([Total runs inns_1], "0") & "/",CALCULATE(FORMAT([Total Wickets Inns_1], "0"),Inns_1[Wicket_type] <> BLANK()))

comment-1730-avatar

Ganesh ch

4 months ago

Hi Logesh please give your phone number