Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Srinivas3350
Helper II
Helper II

can anyone help me in YOY growth by Monthly

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)

Srinivas3350_0-1699462551002.png

 

        )
    )
        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
2 REPLIES 2
Dangar332
Super User
Super User

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

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

Srinivas904_0-1699480953314.png

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors