Year over year & Past value columns showing all blanks

Anonymous — Thu, 27 Jul 2023 02:54:21 GMT

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:

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..

topic Year over year & Past value columns showing all blanks in DAX Commands and Tips

Year over year & Past value columns showing all blanks