topic Re: Max Revenue by Month Issue in DAX Commands and Tips

Max Revenue by Month Issue

LizK75 — Tue, 04 Feb 2025 16:45:59 GMT

I have two tables:

IN for Invoice (contains amount and date columns) - date column is in format of Year Month
Date (contains Year, Year Month, Month, and date columns)

I’ve created a relationship between IN and Date on the Year Month column (many-to-many relationship). I’ve also defined a measure (Total Revenue):

TotRev = SUM('IN'[amount])

I’m trying to create a table visualization with the following columns:

Month (from the Date table)
MaxRevenue: This should display the maximum revenue globally.

MaxRevenue = MAXX(ALLSELECTED('Date'[month]), [TotRev])

What I have

Janv	23300
Feb	20500
Mar	24900
Apr	18900
May	11235
Jun	9000
Jul	6500
Aug	22750
Sep	33000
Oct	33000
Nov	26750
Dec	22125

What I want

Janv	33000
Feb	33000
Mar	33000
Apr	33000
May	33000
Jun	33000
Jul	33000
Aug	33000
Sep	33000
Oct	33000
Nov	33000
Dec	33000

Re: Max Revenue by Month Issue

Jihwan_Kim — Tue, 04 Feb 2025 17:00:13 GMT

Hi,

I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Amount measure: = SUM('IN'[amount])

expected result measure: = MAXX ( ALL ( 'Date'[Year], 'Date'[Year-Month sort], 'Date'[Year-Month], 'Date'[Month name], 'Date'[Month number] ), [Amount measure:] )

Re: Max Revenue by Month Issue

LizK75 — Tue, 04 Feb 2025 17:45:01 GMT

Thanks it works.
I forgot to add 'Date'[Month name] which is crucial.