Forum Discussion
Maximum values based on two col
Hi all, I have a table called 'Group' with the following table structure: Group Month Value group 1 1 50 group 1 1 100 group 1 1 175 group 1 2 100 group 1 3 100...
Hi edhans amitchandak ,
thank you for your replies. Is it possible to create a new table with the resultset? I need this table for comapring the maximal value with the current value.
Thank you in advance!
Hi Anonymous , I don't think you need a separate table. Look at this:
To do this
1) Add the Value field to your table and tell it to Don't Summarize. This will show all of the values without aggregating.
2) Change your Max Value measure to this:
Max Value =
CALCULATE(
MAX('Table'[Value]),
REMOVEFILTERS('Table'[Value])
)3) Add a new Current vs Max Value measure:
Current Value vs Max =
VAR varCurrentValue = MAX('Table'[Value])
RETURN
[Max Value] - varCurrentValue
If that is not what you need Anonymous, please provide the specific output you need, a screenshot from Excel is fine for expected output.