Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Distinct months..?

Hi, I have dates in a table with the format yyyymmdd. I want to populate a list in a report with distinct months with the format mmm How can I do this?   Kent J.
  • Anonymous's avatar
    Anonymous
    4 years ago

    I created a copy of the column ProductionDate with the format 'mmmyyyy'. Then I grouped by the copy (MonthYear) and summarized 'ItemCount'. Success!

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Hi Anonymous 

You may try

Month =
VAR CurrDate =
    SELECTEDVALUE ( Table[Date] )
RETURN
    FORMAT ( DATE ( 1, MONTH ( CurrDate ), 1 ), "mmm" )