Date column not found - rolling 52 weeks of data changes every week

[StrictlyNicola]

Hi

I use excel data with 52 weeks worth of data. The data periods change every week as the last week drops off and the new week adds on. I get an error message every week because power BI can't find the date that dropped off. Is there any way to prevent this happening?

[StrictlyNicola · Accepted solution]

Thank you @serpiva64 - I have had some help and think it is resolved by removing a step which was auto-created in my query. This seems to have fixed the problem!

[serpiva64]

Hi,

the problem is in your query. You hardcoded your data in the name of the column. You need to make it dynamic.

You can find many tutorial in Youtube. 

If you can post some sample data probably is possible to solve it.