last 8 week in filter is wrong

[Pikachu-Power]

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 wrong. sunday 29.03.2020 is missing. does someone know why?

many thanks.

pikachu-power

[amitchandak]

@Pikachu-Power 

There is idea going on this : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37979920-by-default-the-relative-...

Refer if this file can help you: https://www.dropbox.com/s/a9xq913pgvuzg2x/sales_analytics_weekWiseMon_sun.pbix?dl=0

[Pikachu-Power]

are there some workarounds then?

[astojanac]

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

[Greg_Deckler]

Probably because it considers that weeks start on Sunday? So, new week?