Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a question of calculating the total cost of each work order divided by the count of cost. There are duplicates in the total cost for each work order and the count is used to get the actual cost. See example below, where sometimes the cost is duplicated three or two times etc.
Solved! Go to Solution.
@calvgo ,
sumx( values(Table[Work Order]),Quoted Cost = DIVIDE([Planned Cost],[Count of Planned Cost]))
@calvgo ,
sumx( values(Table[Work Order]),Quoted Cost = DIVIDE([Planned Cost],[Count of Planned Cost]))
Super thanks amit!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
41 | |
19 | |
19 | |
16 | |
15 |
User | Count |
---|---|
49 | |
26 | |
22 | |
17 | |
16 |