Offset Function not working on Month year dimension column and calculate

[gvenkatesh482]

Hi Community,

I am trying to use offset function to get previous value for each row . So , i created a measure as shown below. 

However, it is not working as expected. Kindly assist on same. 

b =

    CALCULATE(average( [level_percentage]),OFFSET(-1,ALL('Monthly Calendar Table'[Month Year]),orderby('Monthly Calendar Table'[Month Year],asc)))

Venkatesh

[gvenkatesh482]

Yes Thanks a lot @Jihwan_Kim . It worked . Thanks for sharing the link for reference. 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but I guess [Month Year] column is sorted by another column. In case the sort-by-column is involved, the measure has to include this sort-by-column as well.

https://jihwankimcscp.wixsite.com/supplychainflow/post/when-can-i-use-offset-dax-function-in-power-b...

I hope this helps.