Forum Discussion

pfarahani's avatar
pfarahani
Helper II
5 years ago
Solved

Use MIN for date, display Month

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
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    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"    
)

     

2 Replies

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    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"    
)

     

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    5 years ago

    Hi,

    Does this work

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