Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to 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!
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!
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.