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

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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:]
)