Forum Discussion
Return Selected Value in calculated Column
- 5 years ago
Anonymous No. Colums are calculated at the time of data refresh/load and thus cannot be influenced by user interaction. You will need to use a measure.
- 5 years ago
Anonymous , No can not use slicer value can not be used in a column. You need to think it the term of measure. Try to use the row context to get the right calculation.
Like in this values/summarize has been used to push row context in date diff calculations https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
Anonymous , No can not use slicer value can not be used in a column. You need to think it the term of measure. Try to use the row context to get the right calculation.
Like in this values/summarize has been used to push row context in date diff calculations https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451