Forum Discussion
Return Selected Value in calculated Column
Hi everyone!
Is there anyway to return a selected value in a calculated column?
When i try this the column just return blank.
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.
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
2 Replies
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.
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