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