Date column + 30 days

[Anonymous]

Hi, 

I have a date column in a fact table; I am wanting to create a calculated column that will list the date that is 30 days from the date. 

How do I do this?

[v-juanli-msft · Accepted solution]

Hi @Anonymous

create a calculated column that will list the date that is 30 days from the date

if leap year; When month is February; [date] + 29 days; else, when month is february; [date] +28 days

For your requirements, I would suggest as below

create calculated columns

Column = IF(DAY(EOMONTH([date],0))=28,28,IF(DAY(EOMONTH([date],0))=29,29,30))

Column 2 = [date]+IF(DAY(EOMONTH([date],0))=28,28,IF(DAY(EOMONTH([date],0))=29,29,30))

Best Regards

Maggie

[Washivale]

HI,

next date = date + 30 , should work just fine.

[Anonymous]

Yes is should. Hey Queen, what about February? Just curious. 

[Anonymous]

hm.  It seems there should be some type of condition placed at som point. Here is my "fake" brainstorming that could possibly develop into a dax equation:

if leap year; When month is February; [date] + 29 days; else, when month is february; [date] +28 days

Any help?

[Washivale]

Hm..
tblDate[Date] + IF( DAY(EOMONTH(tblDate[Date])) = 28, 28, IF( DAY(EOMONTH(tblDate[Date])) = 29, 29, 30))