topic can anyone help me in YOY growth by Monthly in DAX Commands and Tips

can anyone help me in YOY growth by Monthly

Srinivas3350 — Wed, 08 Nov 2023 16:58:01 GMT

AS i AM HAVING YoY growth table with fiscal calender where iam using this measure

ASP Growth =

VAR CY = [REV]

VAR LY =

CALCULATE(

[REV],

DATESBETWEEN('Table'[DATE],

EDATE(MIN('Table'[DATE]),-12),

EOMONTH(MAX('Table'[DATE]),-12)

)

RETURN

CY-LY

but it is not accurate for all months i have pointed some major differences it should calculate current year month - PY month i dont what is the issue for some months the values are not accurate i am using fiscal calendar. can anyone help me this is an urgent for me

Re: can anyone help me in YOY growth by Monthly

Dangar332 — Wed, 08 Nov 2023 17:48:46 GMT

hi, Srinivas3350

try below

ASP Growth = VAR CY = [REV] VAR LY = CALCULATE( [REV], DATESBETWEEN('Table'[DATE], EDATE(MIN('Table'[DATE]),-13)+1, EOMONTH(MAX('Table'[DATE]),-12) ) ) RETURN CY-LY

Re: can anyone help me in YOY growth by Monthly

Srinivas904 — Wed, 08 Nov 2023 22:02:43 GMT

Hi Dangar332 when i used your dax the values are coming completely differnt