Forum Discussion

clock0928's avatar
clock0928
Helper I
2 years ago
Solved

WeekOfYear showing data from multiple years

Hi all,   I have a calendar table and in the calendar table I have a "WeekOfYear" column. When I use the WeekOfYear column in a table visual, the resulting data alongside WeekOfYear is showing fo...
Need Help
  • clock0928's avatar
    clock0928
    2 years ago

    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 drop

    ALL('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.

lbendlin's avatar
lbendlin
Super User
2 years ago

What a remarkable reply. (Even a little ironic given your username). Do I have your permission to use this as an anonymized quote?

clock0928's avatar
clock0928
Helper I
2 years ago

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 drop

ALL('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.