Forum Discussion

lakshnajha's avatar
lakshnajha
New Member
10 years ago

visualization monthly - need help

hi

i have data by date and need to summarize monthly to show on bar chart

i had seen before an option where i could select on my createdat filed as monthly but now i dont see it

pls help

 

 

1 Reply

  • greggyb's avatar
    greggyb
    Resident Rockstar
    10 years ago

    You can create a month field in your date dimension, and should do so anyway:

     

    // Power Query
MonthNumber =
Date.Month( [Date] )

MonthName =
Date.ToText( [Date], "MMMM" )

MonthNameShort =
Date.ToText( [Date], "MMM" )


// DAX
MonthNumber =
MONTH( DimDate[Date] )

MonthName =
FORMAT( DimDate[Date], "MMMM" )

MonthNameShort =
FORMAT( DimDate[Date], "MMM" )