Forum Discussion

FredBus's avatar
FredBus
Frequent Visitor
3 years ago

Filter quantities by calendar weeks using a slicer

Hi @ all, I need some help to create a measure or calculated column. I want to filter quantities by calendar weeks using a slicer. Given data model: Dimension table "Date," fact table "Sales Line...
some_bih's avatar
some_bih
Icon for Community Champion rankCommunity Champion
3 years ago

Hi FredBus I understand you do not have Date table with week columns. On link below you can find details about WEEKNUM function to retreive number from Date column. Connect, if not already your Date table with fact and than use slicer. Hope this help

https://learn.microsoft.com/en-us/dax/weeknum-function-dax