Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Filtering by dates in two columns

I have a set of data that looks like the below table.  As you can see it has two date columns, the settlement (when it was bought) and the maturity (when it was sold).   I would like to be able to ...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Unfortunately I'm not able to recreate what you've done.

  • is there supposed to be a [Date] after 'Calendar B' in the below code?

    Cost B = CALCULATE(
    SUM('Table (B)'[Cost]),
    KEEPFILTERS('Calendar B'),
    ALL('Calendar'[Month])
)
  • what are the relationships betwen calendar A & Calendar, and Calendar B & Calendar?  are you linking date to date in both of these?
SergioSilvaPT's avatar
SergioSilvaPT
Resolver V
4 years ago

Yes, as you can see in the photo of the model you should connect then all with the date column, but it's important to keep the relationship direction.

 

Tell me if you need further help.