Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.