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]]] ))
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.