Compute Total per Month

Questions & Answers
1

Hi Everyone,
I have a condition which will get which ever if Higher time spent per month or Monthly Allowance (Monthly), but also I want to all the total of every month
e.g.

Month Time spent Monthly Allowance Get
March 19h 20h 20h
April 10h 20h 20h
May 30h 20h 30h
June 25h 20h 25h
95h

how can I get this Total,
Thank you

2

Hi @Jan_Albert_Panganiba

Welcome to the Community! :sunny:

You can define a new calculated measure in the Measures dimension with a formula like this:

-- annotations.total=sum
Max(
  {[Measures].[Time spent],
  [Measures].[Monthly Allowance]}
)

This should return the Max value from these two measures for each row.

​Best regards,
​Nauris