Forum Discussion

PhotoBiker's avatar
PhotoBiker
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Problem with "DateAdd" as measure

 Hi,   I'm trying to add 6 months to a list of dates.   I'm connecting Power BI "live" to an SSAS data model, therefore I can't add calculated columns (which otherwise would be the simplest solut...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I had this problem too, besides using the EDATE function you can also use the DATEADD function but you need to append .[Date] to the column containing the date.

 

Add To Referral Date = dateadd('FACT Services'[Service Referral Date].[Date],6,MONTH)

Add To Start Date = dateadd('FACT Services'[Service Start Date].[Date],6,MONTH)

 

There are other date related options to append, the complete list is

[Date], [Day], [Month], [MonthNo], [Quarter], [QuarterNo], [Year]

 

These options aren't in the MS DATEADD documentation.

[UPDATE:
Since posting the above reply I have learned that DATEADD generates a table, hence why using this to populate a column failed or required hacks. The correct function to use is EDATE which returns a date.
https://docs.microsoft.com/en-us/dax/edate-function-dax 
https://dax.guide/edate/  ]