Display latest month with text "Mid" for certain dates.

[matrix_user]

Hello,

I am currently using this DAX measure to display the latest month in a card visual. Is they anyone who could help modify this measure to display just before the month, the word "Mid -" when I import mid month data into my Power BI. Mid month data being the 15th of each month. I am not sure how it would work if for mid-month reporting my data goes only till the 12th etc for that particular month.

L/month = Calculate(Format(Max('Facttable' [Entry date]), "MMMM" & "YYYY"))

Any help would be appreciate.

[matrix_user]

I am not sure why I would need to abandon my curernt calendar and rebuild with a customer code calendar. This would mean re-aligninging my measures to the new calendar. 

I thought it could be a possibility to rewrite the DAX I am using to pickup up any loaded dates that registers as the 15th and displays 'Mid' (of whatever month is the latest in the date loaded. I am not particulary wanting to display data or counts etc relevant to mid months, just display the term "Mid" June/July/September etc whenever it have mid month data loaded.

[ChenwuZhu_Gmail]

Hi @matrix_user ,

Maybe you can try this code:

if mid month = 
IF (
    DAY ( MAX ( 'table'[date] ) ) > 15,
    FORMAT ( MAX ( 'table'[date] ), "Mid mmmm" ),
    BLANK ()
)

Best regards.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[matrix_user]

ChenwuZhu_Gmail,

I tried but I am now getting 1i30 - January 1900

If mid month = IF(MAX('Calendar'[Day]) >15,

FORMAT(MAX('Calendar'[Day]) "Mid MMMM" & 'YYYY"), BLANK())

Thanks for the suggestion anyway.

[amitchandak]

@matrix_user , refer to my custom calendar code

https://medium.com/chandakamit/cheat-sheet-calendar-that-starts-with-any-date-of-the-month-just-two-...

DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar
https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s

Then you need period rank and period day for time intelligence, which I have explained in

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s