Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
6 years ago

last 8 week in filter is wrong

hi all, i have a question concerning a filter in power bi desktop in the new filter pane. when i use relative date and say show me the last 8 week it gives me 02.02.2020-28.03.2020. but that is wro...
Need Help
Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
6 years ago

are there some workarounds then?

astojanac's avatar
astojanac
Icon for Helper II rankHelper II
6 years ago

Hello Pikachu-Power , 

My suggestion for you is to create calendar table with column 'Week Number' and then to use 'Week Number' in slicer and on that way select as many weeks you need.

 

Dax for coulumn: Week Number = WEEKNUM(Calendar[Date], 2)  

Numer 2 in dax means that week starts on Monday. 

Best regards, 
Alex