Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

2 date ranges for data

I am currently working with a large data set and I am using created date as the driver for the majority of my reports. Currently created date spans from 01/01/2016 to current day but will be includin...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

What I currently have is for last year and this year, but my date range is going to be expanding back by a few years and what I am being asked to do is to have 2 date filters for the graphs so that they can compare any 2 time periods they want.  I created the calendar table and I thinked it to my property table with the date field to both of my create dates...should I have put 2 date fields in the calendar table one for each create date I am wanting to filter on?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Anonymous,

Please help to share sample data of your table and post DAX you currently use.

Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

     

    AxisCurrent View with no dataHere are some pictures.  filtersmappingHow I want it to work using created date filters and how it is currently working showing year over yearHow do I show the data set?