Forum Discussion
Days Beetween deliverydates
I have a table with different order numbers, different materials and different delivery dates. I would now like to have the number of days of the delivery date per material evaluated. In Excel I had...
Hello RWWRRW you can use NETWORKDAYS DAX and create a measure and dont forget to mention ALLEXCEPT for the material column so that it will pick days for each material individually.
Your measure should look like this:
Duration = Calculate(Networkdays(Start_Date,End_Date),ALLEXCEPT(Table_Name, 'Table_Name'[Material_Column]))
This will give you the duration for each material individually.
If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!