Solved: Measure to filter days between operations - Page 2

Tommyvhod · ‎10-15-2019

Hi guys

I am quite new to power BI and I am stuck with a report I would like to make.

I have a list of IDs from production. We have in production 50 operations each with different number (e.g-20-50-70-80 ...) after finishing a part on each operation a finish date is added for the given operation. Additional thing is that the order of these operations are not alwazs the same but the IDnumber of the operation is always ascending ( 20-30-50-80 or 20-30-70-80 or 20-70-90 .... )

What I would like to make is: for all the IDs know the days between each operation ( and of course the whole production time for one ID) in days.

E.g:

ID	Operation ID	Finish date
48097	10	1. 10. 2019
48097	35	3. 10. 2019
48097	50	4. 10. 2019
48097	70	4. 10. 2019
48097	80	7. 10. 2019
48097	90	9. 10. 2019
48097	110	11. 10. 2019
48097	165	11. 10. 2019
48097	210	13. 10. 2019
48104	30	1. 10. 2019
48104	35	1. 10. 2019
48104	50	2. 10. 2019
48104	70	5. 10. 2019
48104	110	8. 10. 2019
48104	135	11. 10. 2019
48104	180	13. 10. 2019
48104	190	15. 10. 2019.

Thank You very much

Nathaniel_C · ‎10-15-2019

Hi @Tommyvhod ,

Try these two measures to get the result in the picture. My table name is Fin.
Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

Date diff = 
VAR _Time =
     ( Fin[Finish date] ) //captures current date


Var _maxLastTime = CALCULATE(MAX(Fin[Finish date]),FILTER(ALLEXCEPT(Fin,Fin[ID ]),Fin[Finish date]< _Time))

var _datedif =DATEDIFF(_maxLastTime,Fin[Finish date],day)

return
if(_datedif>0,_datedif,0)

==================

Date Dif per ID = CALCULATE(DATEDIFF(MIN(Fin[Finish date]),MAX(Fin[Finish date]),DAY),Filter(ALLEXCEPT(fin,Fin[ID ]),Fin[ID ])

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

View solution in original post

Measure to filter days between operations

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024