Forum Discussion
Impactful Individuallast 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 wrong. sunday 29.03.2020 is missing. does someone know why?
many thanks.
pikachu-power
4 Replies
- Greg_Deckler
Community Champion
Probably because it considers that weeks start on Sunday? So, new week?
- amitchandak
Super User
There is idea going on this : https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37979920-by-default-the-relative-date-slicer-set-sunday-as
Refer if this file can help you: https://www.dropbox.com/s/a9xq913pgvuzg2x/sales_analytics_weekWiseMon_sun.pbix?dl=0
Pikachu-Powerare there some workarounds then?
astojanacHelper II
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
