Forum Discussion
jithinrg
Helper I
Helper ICreate a best model out from a specific dataset
Hi team, I would like to model this dat in PowerBI. Scenario: Need to identify the actual sales of each employee listed in the Employee table. In the sales table, tmp ids are distributed over mult...
see attched. you will need to play with the visual more to get what you want but please see if this is what you were after.
vanessafvg
Community Champion
Community Championwhat field defines who made the sale, the partners? consultant? if there are multiple employees per sale, you would still attribue the total sales value per sales person?
jithinrgHelper I
Helper Ithe list of empids in each column are a part of the sale...hopefully we have to combine all empid fields to make a field for all empids and transpose? not sure whether that approach is correct.