Forum Discussion
date between start and enddate
Hi, I have a separate dates column and another table where I have members with a start and enddate. I have to find a way to check if in the members table the date falls between start and enddate ...
Calculated columns are not dynamic, they're STATIC - they're calculated when you refresh the model and stay put until the next refresh. That's one thing. Secondly, which date out of the many dates you have in the Dates table would you like to use to perform this calculation in each row? This value can't be taken from a slicer since... calculated columns are STATIC.