Newbie here! Any help would be very much appreciated!
Table 1 (unique ID)
Net amount based on uniques ID
each Employee or Team could have multiple IDs.
|ID||Employee or team|
Table 3 ( the result)
The result I'm seeking is an aggregated net amounts by unique (employee or team), as a Table in Data tab not in
Report tab in Power bi.
FYI, I have managed to get the below result in the report tab but couldn't replicate the table in the Data tab.
|Employee or Team||net|
Relationship between Table 1 and Table 2 ( one to many, 1---->----* )oneway.
Thanks in advance
Solved! Go to Solution.
Thank you so much @CNENFRNL for the quick reply. I'm looking for the same result but as a table in The Data tab not in report tab. I was able to the same thing. The challenge here is to Create a New table from 2 different tables
Thank so much @CNENFRNL for your reply, I don't want to take advantage of your kindness. but if I want to build on your first reply
I want to create a slicer with 2 bottons (top 5 bottom 5) when I select top 5 the green part will be selected and when I select bottom 5 the red part will be selected.
by the way, the below table is the same as the one right above but ranked this time!
if you could help with this I will be very grateful. whenever you are free! thanks again!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.