Versus previous

[Hussein_charif]

Hi, i wanted to check if there is a similar function to the previous() visual calculation function but with measures?

Also, i have this visual calc:
Diff
IF(
ISINSCOPE([itemno]) &&
NOT ISINSCOPE([year]) &&
NOT ISINSCOPE([monthname]) &&
NOT ISINSCOPE([day]),
BLANK(),
IF(
ISBLANK(PREVIOUS([Total AVG Cost])),
0,
IF(
ISBLANK([Total AVG Cost]),
0,
[Total AVG Cost] - PREVIOUS([Total AVG Cost])
)
)
)

In the photo, you can see i have multiple itemNo. For the first row, for example itemNo 10002, the difference there is doing total avg cost of year 2022 of itemNo 10002 - total avg cost of year 2024 of itemNo 1, which is wrong. What can i do in this case to prevent the previous function from taking the total avg cost of different years?

[Anonymous]

Hi @Hussein_charif ,

Please provide sample data as well as your expected results.

Best regards,
Community Support Team_ Scott Chang

[lbendlin]

There are no row numbers in DAX - you need to provide your own by specifying how you want the data sorted. Once you have that you can use the Window functions like OFFSET.

[Hussein_charif]

okay well, is there a way to solve the problem within visual calculations?

[lbendlin · Accepted solution]

Yes, by using PREVIOUS() and indicating which direction you want to look.

[Hussein_charif]

used PREVIOUS([Total AVG Cost],1,-1) and it worked, thank you