Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Everyone,
I have the following model and I need to find the 3 most company in a Group, base on the value of a particular KPI, (this filter should be dynamically in time), and for these 3 company (and the Group level if possible) I should show all the other KPIs
https://drive.google.com/file/d/1TAetPxNFspnyM1plcsMojtvY7x4qALxB/view?usp=sharing
Any idea how to make it?
Thanks
This is what should i expect:
I got N groups, each of them have N different companies. Base on Ebit (which is the KPI), i need to find for each Group, the 3 Company which have the highest EBIT (and these should be in relation of time, Trim and year). Once I determining the Top 3 Companies of each groups, for particular Trim of particular Year, for this 3Top i should show the data of all the Scenarios (Actual, BDG, Forcast, act vs bdg ...) of others KPI (Ebitda, PL, cOST, and Deltas, including the EBIT).
In the file i just reproduce the model i have, and how should i represent the data
(I put 2 Groups with 5 companies (in order to find the top 3) , 2 year, 3 Trim, 4 indicators, 7 scenarios,
Hi,
Your question is not clear. In the file that you have shared, show the expected result very clearly.