Forum Discussion
Helper ICreate a new column depends on a dynamic date
yj1111 In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Community Championyj1111 Columns are not dynamic based on user input, they are calculated at the time of data refresh. You would need to use a measure.
yj1111But if I use a measure, I am not able to use the slicer to show which projects updated the highlight reports, which not. Do you have an idea how I can show projects with different update status?
- Greg_Deckler
yj1111 In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563