We have a pool with several contributors in it. The total sum of the pool value has descreased overtime. How can I find which contributor(s) had the largest drop of the pool value overtime ?
Below is an example on how our data looks like, and it runs over two years and have 5,000 contributors. The date column is a full date column the is hierarchied.
In Jan we know the pool value was 1,750,000, in Mar 1,210,000. How to find which contributor is the most responsible of this reduced value ? Thanks 😁
Go to Solution.
You could do something like:
Bottom Contributor Value =
) = 2
Bottom Contributor =
) = 1
Proud to be a Super User!
View solution in original post
Click here to learn more about the September 2022 updates!
Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community updates.
Watch Session 25 of Ted's Dev Camp.