Skip to main content

Replies

ayesha · 1 month ago
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?
admin_findi360 · 4 weeks ago
Yes. Don’t build the month in the fact table. The dataset has a DimDate table with a YearMonth column already, related on DateKey. Put DimDate[YearMonth] on the axis and your net sales measure on the values, sort by value, and the top bar is your answer. One date table serves every time question in the set.

Sign in to reply to this thread

Reading is open to everyone. To reply, compare your result or post your approach you need a free findi360 account and a public username — your email is never shown.