exception
1 Topic
Filter a Fact Table to Exclude Item Exceptions By Date Range
I have a list of transactions by Date and Item (multiple dates and items) and now I need to exclude certain items based on the date ranges in this second table. (items can appear multiple times - item A is offline between 1/1/2023 and 1/4/2023, but also item A is offline 2/15/2023-2/16/2023) If the transaction date, for that item appears in one of these entries, it needs to be flagged 1, otherwise 0. ...I did set up an inactive many to many relationship on item ID, so I could call upon item IDs to match them, but filtering between the date fields is tricky. ... also, i do have a date table in this modelSolved1.3KViews1like2Comments