fixing a filter based off a start and end date

[foxtrottango]

Hello

Need help - I can't figure out where the error is here

I have a excel sheet feeding i nto my powerBI report and the trigger Qty in Column G is 24,187 with 23 promos in the period 

but when i run the same report in powerBI - it's takign in multiple years and my total don't filter or match up

I am using a date table to filter but am wonderign have i done osmethign wrong in cratign relationships in my model?

[v-shex-msft · Accepted solution]

HI @foxtrottango,

It seems like a common multiple date fields range analysis requirement, I'd like to suggest you take a look at the following blog 'start date', 'end date 'parts of help:

Before You Post, Read This: start/end date 

Regards,

Xiaoxin Sheng