Forum Discussion
Adding sum FEU by week column
Hi,
I work in supply chain and am working on a project for my company in which I project weekly costs. I am fairly new to PowerBI, so I am having some difficulty determining how to create a column in my "projections" table that sums each week's total FEU (currently the table has a column for each day of the year, the FEU on that specific day, and week of the year that each day falls under). Essentially I want a column that lists the total FEU by week, and not just by day, but I am having trouble figuring it out. Thoughts? Thanks so much.
2 Replies
Hi Anonymous
According to your description, it is more recommended that you use measure.
"currently the table has a column for each day of the year, the FEU on that specific day, and week of the year that each day falls under", Could you please share some sample data of that table? you can use bogus data to replace your raw data, for example,
And could you please share the expected result according to the sample data? Thanks
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi,
See below. Essentially, I am looking to determine how to sum FEU by week so I can then determine FEU cost per week, if that makes sense. Thanks!
WEEK_OF_YEAR LIST_COST ESTIMATE_FEU SUM_FEU_BY_WEEK WEEKLY_COST_FEU 20 $2,000 0.03 20 $2,000 0.03 20 $2,000 0.03 20 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03 18 $2,000 0.03
