Hi. Relatively new to Power BI and having trouble calculating the difference between dates in the following situation. The first four columns below are part of a report I am creating to track HR hiring actions by the action ID and the individual process steps. I am trying to create a measure or column (DaysBtwSteps) that calculates the elapsed days between each step and the previous one for each HR action.
I’ve tried to adapt the DAX code I’ve found in similar forum posts, but where I get stuck is the situation below where multiple steps get completed on the same day. In this situation, I want DaysBtwSteps to return the elapsed days for the first event on that day, and 0 for all subsequent events on that same day. The DaysBtwSteps column below is how I would like the measure/column to work.
Any assistance on this would be greatly appreciated.