Struggling to create a Z-Score Column using DAX

Hi All,

I am quite new to powerbi and I am struggling with creating a z-score. 

I am trying to create individual z-scores for distance covered by football players given a specific day of training. 

For example, every week, players will do a MD-4 session, MD-3 session, MD-2 session and a MD-1 session.

I would like to be able to give a z-score for each player for the specific "Match day code".

Unfortuantely I could not figure it out and tried (badly) to create something with this DAX to create a Z-score Distance Column. 

My data looks like this in a table called TBLLoadDump:

 

 

So for example, for the 05/07/2022, for Player 16, I would like their individual Z-score.

Their score of 4873.78 - their average for a MD-2 / their Standard deviation for a MD-2 .

Would anyone be able to help? 

 

Thank you! 

Lewis