Forum Discussion
Dynamic Week Offset based on Slicer Value
Ok.. been staring at this for too long and need help. I have a date table where I use a Week Counter and then Calculate to determine the Week Counter value for current week based upon TODAY() being ...
Hi there. Would you please be more descriptive about this problem? Also, would you please format code using https://www.daxformatter.com/? However, from what I understand, you want to have something dynamic that will change based on a value taken from another table (slicer). Well, in such a case you have to create a measure, there is no way to put it in a column. Please remember that a column creates (static) values when the model is loaded/refreshed. You can only have a measure that will respond to selections in a slicer.