Forum Discussion

Corleen's avatar
Corleen
Regular Visitor
9 years ago
Solved

Sum by Maximum Month

Good day   I have created the following measures   Expenditure = CALCULATE(sum(Balance[Balance]), Balance[Account Type] = "Expenditure") ~ this gives me sum of the balance where account type is  ...
  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    Corleen

     

    You can try this measure and show the result in Card visual.

     

    HighMonthSum =
VAR HighestMonth = [Highest Expenditure Month]
RETURN
    CALCULATE (
        [Expenditure],
        FILTER ( Balance, Balance[bookkeeping month] = HighestMonth )
)

     

    Best Regards,
    Herbert

Corleen's avatar
Corleen
Regular Visitor
9 years ago

Good day

 

I have the following measures

 

Expenditure = CALCULATE(sum(Balance[Balance]), Balance[Account Type] = "Expenditure") ~ this sums all the balance values where account type is equal to Expenditure

 

Highest Expenditure = CALCULATE(max(Balance[Balance]), Balance[Account Type] = "Expenditure") ~ this gives me the maximum balance where account type = Expenditure

 

Highest Expenditure Month = LOOKUPVALUE(Balance[Bookkeeping Month],lBalance[Balance],[Highest Expenditure]) ~ this gives me the month (201509) which have the highest Expenditure 

 

I want to create a measure that sums the Balance's for Expenditure and is in the Highest Expenditure Month

 

Thank you