Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi forum
I would appreciate your help on the following matter:
down below you can see an example table. I would like to calculate the column Lifecycle based on:
partnumber & the date difference between the applied action install.
I hope the example table explains better what I am trying to do (calculate lifecycle in days --> for each partnumber if install dates are available - lifecycle intervall is last install date subtracted by the the install date before).
I am kind of new to Power BI and DAX so I would really appreciate it if somebody could help me on that matter.
If the example I am showing is not doable in Power BI or you need any further information please let me know.
Solved! Go to Solution.
Try this Calculated Column
LifeCycle = VAR CurrentDate = TableName[Date] VAR PreviousDate = CALCULATE ( MAX ( TableName[Date] ), FILTER ( ALLEXCEPT ( TableName, TableName[PartNumber] ), TableName[Action] = "Install" && TableName[Date] < CurrentDate ) ) RETURN IF ( NOT ( ISBLANK ( PreviousDate ) ) && TableName[Action] = "Install", DATEDIFF ( PreviousDate, CurrentDate, DAY ) )
Try this Calculated Column
LifeCycle = VAR CurrentDate = TableName[Date] VAR PreviousDate = CALCULATE ( MAX ( TableName[Date] ), FILTER ( ALLEXCEPT ( TableName, TableName[PartNumber] ), TableName[Action] = "Install" && TableName[Date] < CurrentDate ) ) RETURN IF ( NOT ( ISBLANK ( PreviousDate ) ) && TableName[Action] = "Install", DATEDIFF ( PreviousDate, CurrentDate, DAY ) )
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
68 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |