Forum Discussion
BratKat
Microsoft Employee
Microsoft EmployeeWeekly data and slicer
Have a graph that uses a Slicer (using between) and a measure to get each week per a column of the dates we reference. MonthWeek = 'Work Items'[Team Date 01].[Month] & " Week " & WEEKNUM('Work Ite...
BratKat, changing your analysis to the week of the year would give you better results as week of month analysis is fundamentally flawed for comparable analysis.
If you are slicing by month & week, you will get strange and incomparable results in your visualizations. I would suggest not going about it this way. For example, if the first or last week of the month had anything other than 7 days in them (which they always do), then they would not be comparable to anything and would give misleading results.