Transform Date field by using custom parameter

[brothaprice]

How can transform a date field called "FinalDate" not using the standard date parameters? I would like to transform it by the year and whichever half of the month it is. The 1st half of the month would constitute the first 15 days of the month and the 2nd half would constitute the remaining. So May 2019-1st half for example. How can I do this?

 

[JustynaMK]

Here's a solution using DAX column (go to Data > select your table > Column tools > New column):

    FinalDate = 
        var Half = MIN(ROUNDUP(DAY(tblDates[Dates]) / 15, 0), 2)
    return
        FORMAT(tblDates[Dates], "mmm yyyy") & " - " &
        IF(Half = 1, "1st half", "2nd half")

 

[Kerryx]

or formula where b1 contains your date
=IF(DAY(B1)<=DAY(EOMONTH(B1,0))/2,CONCAT(TEXT(B1,"mmm yyyy"),"-1st half"),CONCAT(TEXT(B1,"mmm yyyy"),"-2nd half"))