Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi experts,
I am fairly new to this and already spend some time to find out myself but I am not making much progress so really would appreciate your help:
I have a table with purchases and sales that looks like:
Order.Sales Person | Amount | SalesInvNo | Total Revenue | PO Expenses | Profit | TrType |
-505 | tt555 | -505 | 505 | Purchase | ||
Peter | 2689.2 | tt556 | $2,689.20 | 2689.2 | Sales |
What I am looking for is now a DAX measure or another approach to be able to show
Sales, SalesInvNo, Salesperson, Revenue and expenses in one line. i.e. getting a table where I can see the job profit per invoice?
Thank you very much for your help!
Phil
Solved! Go to Solution.
In the end we came up with a solution: the key problem was that we only had the sales person information set for the sales transactions. So, it was giving us two lines in the visual as one had the sales person name the other one was empty. We added the sales person name via the SQL backend to the purchase transactions and with that got everything in one row as required. If someone has an idea how this could be done with DAX I still would be keen to know!
In the end we came up with a solution: the key problem was that we only had the sales person information set for the sales transactions. So, it was giving us two lines in the visual as one had the sales person name the other one was empty. We added the sales person name via the SQL backend to the purchase transactions and with that got everything in one row as required. If someone has an idea how this could be done with DAX I still would be keen to know!
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |