Forum Discussion
Solved
Filtering week from Date Table
Hi Team, I have the following data and date table is defined as follows DateTable = CALENDAR(DATE(2020,3,1),DATE(2020,4,30)) and Week is calculated as Week = "Week "&(WEEKNUM(DateTable...
Jos13 - Ah, that wasn't really clear from the original email. Well, a few ways of solving that. I suppose the easiest way would be to create a complex selector measure that returned 1 if there were sales in a wee and 0 if not and then just filter on that. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534
