Filter quantities by calendar weeks using a slicer

Question

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?&nbsp;&nbsp;&nbsp;can anyone help?&nbsp;

some_bih · Answer

Hi&nbsp;FredBus&nbsp;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 helphttps://learn.microsoft.com/en-us/dax/weeknum-function-dax&nbsp;

fredbus · Answer

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

some_bih · Answer

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

fredbus · Answer

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-calculate-the-requirment-sub/m-p/3306181&nbsp;

Forum Discussion

Filter quantities by calendar weeks using a slicer

4 Replies

Related content

country based calendar filter

Calendar Slicer with Different Business Calendars

Tweaking Financial Calendar

Custom calendar

Production calendar with quantities