Forum Discussion
Calculate difference in values from the current week
Hello I would like to calculate by formula, the difference in "Calls..." either in values or in %, from last week - the previous one, by category. For example with this last week (53_20)-(52_...
Hi Anonymous ,
Unfortunately, the picture is too vague to provide valid information.
Based on your description, I have created a test file for your reference. The measure is as follows:
Measure = var this_index = MAX('Table'[Index]) var last_week = CALCULATE( SUM('Table'[value]), FILTER(ALLEXCEPT('Table','Table'[category]),'Table'[Index]=this_index-1)) var this_week = SUM('Table'[value]) return this_week-last_weekBest Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Gracias a los 2,
pero solucionado!
LastW = CALCULATE(sum('WEEK Skyline'[Calls SK]), FILTER(ALLSELECTED('WEEK Skyline'), 'WEEK Skyline'[INDICE]=max('WEEK Skyline'[INDICE])-1))ThisW = CALCULATE(sum('WEEK Skyline'[Calls SK]), FILTER(ALLSELECTED('WEEK Skyline'), 'WEEK Skyline'[INDICE]=max('WEEK Skyline'[INDICE])))ThisVSLast = [ThisW] - [LastW]
V-lianl-msft
Community Support
Community SupportHi Anonymous ,
Unfortunately, the picture is too vague to provide valid information.
Based on your description, I have created a test file for your reference. The measure is as follows:
Measure =
var this_index = MAX('Table'[Index])
var last_week = CALCULATE(
SUM('Table'[value]),
FILTER(ALLEXCEPT('Table','Table'[category]),'Table'[Index]=this_index-1))
var this_week = SUM('Table'[value])
return this_week-last_week
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.