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
You can create a month field in your date dimension, and should do so anyway:
// Power Query
Date.Month( [Date] )
Date.ToText( [Date], "MMMM" )
Date.ToText( [Date], "MMM" )
MONTH( DimDate[Date] )
FORMAT( DimDate[Date], "MMMM" )
FORMAT( DimDate[Date], "MMM" )
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.