Forum Discussion
Solved
Calculated column that references another table column if current value is blank
I have a column in a table where some values are blank and need to be populated with a value from another table. the Hours YTD value is what is needed to populate the blanks It need...
if you need it dynamic then it cannot be a calculated column - it has to be a measure.
How are your rows sorted, or does that not matter?
Please provide sanitized sample data in usable format (not as a picture - inserting it into a table would be good, or provide a sample pbix) .