Forum Discussion
current date year and compare same date previous year divide
is there any option to compare current date year and same date year previous year I have current date September 15,2021 . i want to compare same as previous year septemer 01,2021 exactly on...
BeaBF
Super User
Super UserAnonymous Try this:
%Prvs =
var maxxx = CALCULATE(MAX(Data[Period]), ALLSELECTED(Data[Period]))
var actual = CALCULATE(SUM(Data[Revised closing value]), Data[Period] = maxxx)
var prevmm = CALCULATE(SUM(Data[Revised closing value]), DATEADD(Data[Period], -1, YEAR))
var num = actual - prevmm
RETURN (num / prevmm)
Also, when creating this measure, be sure to select "decimal value" and choose 3 decimal places. Box in red:
B.