Forum Discussion

Vatz8's avatar
Vatz8
Helper I
3 years ago
Solved

Create custom date column based on another date

Hi, I want to create a custom date column with displays 15th of every month and the end of the month based on a date column. Any day less than or equal to 15th should display 15th and any day less ...
Get Help
  • FreemanZ's avatar
    FreemanZ
    3 years ago

    please try this 

     

    Output Date =
    IF( 
        DAY(Data[Given Date])<=15, 
        DATE(YEAE(Data[Given Date]), MONTH(Data[Given Date]),15),
        EOMONTH(Data[Given Date],0)
    )
Vatz8's avatar
Vatz8
Helper I
3 years ago

Hi by using this formula I get all the dates with 15. But the endofmonth returns the same date as in the given column.

FreemanZ's avatar
FreemanZ
Super User
3 years ago

please try this 

 

Output Date =
IF( 
    DAY(Data[Given Date])<=15, 
    DATE(YEAE(Data[Given Date]), MONTH(Data[Given Date]),15),
    EOMONTH(Data[Given Date],0)
)