Old Data :
Month Period closevalue
Oct 01 November 2019 10
Nov 15 November 2019 5
Dec 01 December 2019 7
Dec 15 December 2019 17
Jan 01 Januray 2020 27
Jan 15 Januray 2020 17
i have like this upto 2021 last taking percentage calcualtion last weeks but now changed like below
Month Period closevalue
November 01 November 2019 10
November 01 November 2019 5
December 01 December 2019 7
December 15 December 2019 17
January 01 Januray 2020 27
January 15 Januray 2020 17
instead of previous last weeks i want to change to previous Month to define how update it at mid month
Previous 2 Weeks =
VAR LastMAXDate = MAX ( Data[Period] )
VAR currentValue =
CALCULATE (
SUM ( Data[Revised closing value] ),
Data[Period] = LastMAXDate
)
Return DIVIDE((currentValue-[LastweekValue]),[LastweekValue])
Measure 2 :
LastweekValue =
VAR maxdate =
CALCULATE ( MAX ( Data[Period] ), ALLSELECTED ( Data ) )
var seconddate =
CALCULATE (
MAX (Data[Period] ),
FILTER ( ALL ( Data ), Data[Period] < maxdate )
)
return
CALCULATE (
SUM ( Data[Revised closing value] ),
Data[Period] = seconddate
)
any idea .where to change in my measure ? thanks in advance
