Use MIN for date, display Month

[pfarahani]

Hello All,

I have this measure in my DAX formula:

Current M Data = MIN('Dates TEST'[MonthNum]) & " " & MAX ( 'Dates TEST'[Year] )

IS their a way to add to this logic, so that instead of MonthNum I am able to display my Month Name instead. Thanks

[Ashish_Mathur]

Hi,

Does this work

=FORMAT(MIN('Dates TEST'[Date]),"mmmm")& " " & MAX ( 'Dates TEST'[Year] )

[Fowmy · Accepted solution]

@pfarahani 

You can modify your measure as follows or create a new column in your Dates TEST table with Format('Dates TEST'[Date], "Mmmm yyyy" )

Current M Data = 
FORMAT (
    DATE(
        MAX ( 'Dates TEST'[Year] ),
        MIN('Dates TEST'[MonthNum]),
        1
    ) 
    "Mmmm yyyy"    
)