Forum Discussion
WeekOfYear showing data from multiple years
lbendlin - I thought instead of leaving your comment with no response, I would advise that I did not have time to supply you with the data - my apologies again if that offended you.
However, I did work out the solution with the asssist from Copilot.
For future reference and if anyone else gets this form of error within their own report -
All I had to do was dropALL('Calendar')from my measure. As this was resulting in the filter to view the entire dataset across all dates, and not just the ones currently being looked at.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information or anything not related to the issue or question.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
lbendlin - Unfortunately I don't have time available to put together sample data. Appreciate your time though
What a remarkable reply. (Even a little ironic given your username). Do I have your permission to use this as an anonymized quote?
lbendlin - I thought instead of leaving your comment with no response, I would advise that I did not have time to supply you with the data - my apologies again if that offended you.
However, I did work out the solution with the asssist from Copilot.
For future reference and if anyone else gets this form of error within their own report -
All I had to do was dropALL('Calendar')from my measure. As this was resulting in the filter to view the entire dataset across all dates, and not just the ones currently being looked at.