0
I need to create a date column with a condition for comparing existing dates in the "Start Date" column for the same type of equipment. That is, for equipment 1, I need to return in the first row of the column "Next Malfunction" the date of the next malfunction for this equipment, in which case it would be "03/01/2019". How can I be doing this in Power BI?
Note: The database is circled in red. In yellow, the desired results in the conditional column.
