Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to create a new column entitled 'Analyst Daily Average'.
To get this column, you have to use the calculation: (Number of P&Ps Completed) / (Days Worked).
(Number of P&Ps Completed) =
Solved! Go to Solution.
Hi @i820017
Are the two tables related through an Analyst ID or something of the like? If so, you should be able to achieve this.
Please feel free to provide dummy data if you'd like further assistance.
Thanks heaps!
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
I figured it out using MAX...thanks though!!
User | Count |
---|---|
83 | |
78 | |
62 | |
61 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |