Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone!
Is there anyway to return a selected value in a calculated column?
When i try this the column just return blank.
Solved! Go to Solution.
@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
@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. 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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |