SQLDAXExcelPython
LeaderboardRunLifetime
groupby and mergeHard30 points

Share of the group with transform

For each product, set result to ProductName and its UnitPrice as a share of the total UnitPrice of its Category, as a decimal.

Hard questions are part of Lifetime and Pro. Read it here, and unlock running and checking your answer from the plans.

Show solutionLifetime

Real Python running in your browser through Pyodide, with pandas available. Nothing you type is sent to a server unless you save a score.

Python
Loading editor…

Press Ctrl+Enter or Run to see the result here.