Forum Discussion
Filter visual using related table
I have two tables, one is a calendar and the other is a list of job posting details. I am calculating the date a job posts is over a certain age, then using the calendar can make a trend chart showin...
Well, the calendar table should be used as a calendar and nothing more. Making businesslogic calculated column on the calendar table is a big no-no.
The filter isn't woking, because you probably have a one-to-many relationship on your calendar to your table1 (As you should) but that means, that reponsibility from the downhill table (table1) does NOT filter the uphill table (calendar)
Do it in a measure in stead of a calculated column.
As a general rule: Make all calculation in measure, unless you can articulate a good and valid reason for not doing so.
If this post solves your problem, accept it as a solution
Appreciate your kudos