how do you tag specific periods by using Power BI Calendar?

[esero88]

Hello,

I need to create a calculated column in order to tag months. However, these months have to be tagged according to several conditions;

Example: for January it has to include the last 15 days of January and the first 15 days of February

Or for February it has to include the last 15 days of February and the first 15 days of March etc.

I have written a DAX code but it always returns blank values. So please can help me?

DAX: 

MonthExec =

IF(

    AND([DayOfMonth] >= 15, [MonthOfYear] IN {1}),

    IF(

        AND([DayOfMonth] < 15, [MonthOfYear] IN {2}),

        "Jan",

        IF(

            AND([DayOfMonth] >= 15,[MonthOfYear] IN {2}),

            IF(

                AND([DayOfMonth] < 15, [MonthOfYear] IN {3}),

                "Feb"

            )

        )

    )

)

[Ahmedx · Accepted solution]

pls try this

Column =

 FORMAT( 'Table'[Date]-15,"mmmm")

[esero88]

@Ahmedx that solved my problem. Thanks for your reply.  Kudos