convert excel calculation into power bi

[Anonymous]

Hi Community,

I am currently calculating my project status in excel.

Example in Excel:

on time = planned End date

delayed 1-3 month = planned End date + 90 days

delayed 3-6 month = planned End date + 180 days

I would like to do this calculation directly in the power bi to maintain my status

does someone have a solution?

[kcantor]

You should be able to complete this using the DATEADD calculation as long as your dates are in the date format and you have a good date dimension table.  If your columns in your source are named as the sample, try:

on time = [planned End date]

delayed 1-3 month = DateAdd( [planned End date],  90, day)

delayed 3-6 month =DateAdd( [planned End date],  180, day)

See this link for more information.

https://dax.guide/dateadd/