visualization monthly - need help

[lakshnajha]

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

[greggyb]

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