Skip to main content
DD-RET-001 Daily Grocery Sales and Store Performance Get the data →
DD-RET-001-Q019 Medium Time series

Peak sales month

Which month had the highest net sales, and what was the value?
Expected
Monthly table; peak row · Monthly column chart
Tables
FactDailySales, DimDate · columns
  • FactDailySales
  • DimDate
  • NetSalesSAR
  • DateKey
  • YearMonth

Discussion

1 reply
  1. ayesha
    My date column is a full date like 01-03-2025. I made a separate month column and then found the highest month. Is there a shorter way in Power BI without making a new column?

A free account takes a minute. Your draft is kept while you sign in.