Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

fixing a filter based off a start and end date

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?

 

  • Anonymous's avatar
    Anonymous
    3 years ago

    HI Anonymous,

    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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous,

    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