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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Anonymous
Not applicable

Year over year & Past value columns showing all blanks

cheeyayee_0-1690426093235.png

As showing in the above graph, the cloumn of YoY and past year value are all blanks for year 2022, but we have the data for 2021.. But if I also tick 2021 in Year slicer, then values will be there:

cheeyayee_1-1690426307395.png

 

the code for ASP YoY is:

ASP YoY = 

VAR __PREV_YEAR =

    CALCULATE(

        [ASP (Unit)],

        DATEADD('02-01-01 COPA Posting Date'[Full Date], -1, YEAR)

    )

RETURN

    DIVIDE([ASP (Unit)] - __PREV_YEAR, __PREV_YEAR)

I also created individual last year value:

ASP_PY = CALCULATE([ASP (Unit)],DATEADD('02-01-01 COPA Posting Date'[Full Date],-1,YEAR))
so I can use two-step measure:
ASP YoY1 = ([ASP (Unit)]-[ASP_PY])/[ASP_PY]
 
Still, all columns are blanks..
0 REPLIES 0

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.