Forum Discussion

LizK75's avatar
LizK75
Frequent Visitor
1 year ago
Solved

Max Revenue by Month Issue

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 relationsh...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    1 year ago

    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:]
)

     

LizK75's avatar
LizK75
Frequent Visitor
1 year ago

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