Forum Discussion
StSupQ
3 years agoFrequent Visitor
How to remove context from a temporary contextually-calculated table-variable ?
Hello all, I am currently working on a moving average measure. The underlying data i want to smooth that way is already a measure. I am already displaying it on a visual as a fonction of a [Time]...
- 3 years ago
Within the definition of the column you're adding using ADDCOLUMNS you can manipulate the filter context in any way you want, or you can manipulate the filter context in a CALCULATETABLE as in the above example where the date is being manipulated.
StSupQ
3 years agoFrequent Visitor
Thank you for trying to help me.
I still get the same result as my underlying measure, as my context is still inherited from the underlying. Is there no way to extand the time context to the adjacent entries ?
johnt75
Super User
3 years agoWithin the definition of the column you're adding using ADDCOLUMNS you can manipulate the filter context in any way you want, or you can manipulate the filter context in a CALCULATETABLE as in the above example where the date is being manipulated.