Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Date column + 30 days

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?  
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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's avatar
Washivale
Resolver V
8 years ago

HI,

 

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        Washivale
        Resolver V
        8 years ago
        Hm..
        tblDate[Date] + IF( DAY(EOMONTH(tblDate[Date])) = 28, 28, IF( DAY(EOMONTH(tblDate[Date])) = 29, 29, 30))