Forum Discussion
Calculating Job Costs from ERP Job Table...
I need some help with figuring out how to calculate the total job cost from our ERP job cost table. The structure of the table has a column called "Job", a column for "Subjob", and a column for "Job Cost". Depending on the hierachy structure of the job, there can be multiple parent-child relationships to for the job strucutre (see below).
Anonymous
You may try SUM to add a measure and take a look at Using drill down with the matrix visual.
2 Replies
- parry2k
Super User
Anonymous you need to provide sample data with example output. Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 
v-chuncz-msftCommunity Support
Anonymous
You may try SUM to add a measure and take a look at Using drill down with the matrix visual.
