Calculate next week demands based on the combo between year and week

[naoyixue1]

Hey there,

I try to calculate next week demands. That's the fomula what I applied, but it doesn't show any value. I droped the PBIX file here. Would you take a look and let me know your thoughts? Thanks!

That's my fact test table. Column is yearandweek. For example, 2023001 is the 1st week of year 2023. 

That's my lookup table, which highlights the year and week. And I also build the connection between those two tables on the same column (year and week)

[naoyixue1 · Accepted solution]

Sorry, I solved that. Thanks!