Forum Discussion

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Weekly 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's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

MonthWeek column does not appear in Transform Data, unfortunately cannot share my pbix file as it is proprietary as it is FED data. Is there a way to rewrite my current column 

MonthWeek = 'Work Items'[Team Date 01].[Month] & " Week " & WEEKNUM('Work Items'[Team Date 01])
per Noah's suggestion ? Thank you