Filter quantities by calendar weeks using a slicer

[FredBus]

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," and dimension table "Item." Relationships: "Date"[Date] 1 to N "Sales Line"[Date], and "Item" table[Nr] 1 to N "Sales Line"[Nr].

In the "Item" table, the order quantity from the "Sales Line" is aggregated. The order quantity should be filterable using a visual date filter. How can I achieve this?

 
can anyone help? 

[some_bih]

Hi @FredBus share more details about your model / file with example of outuput for given input.

[FredBus]

Hi @some_bih Sorry for my late reply. In the meantime, I have posted a new question in a similar context. Maybe you can help with that?https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Measure-for-production-Bom-table-to-... 

[FredBus]

Hi @some_bih Thank you for your response. My date table is quite extensive. Each individual date is assigned to a calendar week.

[some_bih]

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