DATEADD error - How to subtract days from date

[LABrowne]

Hi there,

I am working with a SQL server based power bi report.

Trying to subtract 90 days from a date this is what I have currently:

DATEADD(Order[ExpiryDate],-90,DAY)

Unfortunately the error message I get is that this formula doesn;t support duplicates.

Is there any work around this?

Thanks in advance for any help!

[VahidDM]

Hey
It seems there are duplicate values in your column ( same date in multiple rows ).And you are using time intelligence functions.
Use this:
Order[ExpiryDate] - 90

Or make sure to add a Date Table and connect it to your table and use that instead.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube 

[LABrowne]

Hi VahidDM,

Thanks for your help.

I use EDATE(MAX(Order[ExpiryDate],-3)) and that seems to work but I'm not sure if that will work with every order.

[VahidDM · Accepted solution]

The () in your formula need to change to EDATE(MAX(Order[ExpiryDate]),-3)

I believe that EDATE for your request is much better if you are looking for finding a date in 3 month before the current because some months have 31 or 28 days and 90 days is not the exact calc.