I need a DAX command that adds up the individual production times of different production steps for different products and outputs them summarized in a column.
Here in the table I have created a small schematic example.
Thanks a lot for your help!
Go to Solution.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Best regards, JiHwan Kim
View solution in original post
Now I have tried to calculate the individual production steps more precisely. Can I add another filter condition to the filter function to get the calculation as shown in the table?
If tryed it with:
Thanks for the help so far!
new table =SUMMARIZECOLUMNS (Data[Product],"@total production time", SUM ( Data[Protuction time (for this step) [h]]] ))
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!