Forum Discussion
Replace values
Hi, Background I have two spreadsheets. Table 1 is a 'master' document and table 2 is a change log that records any changes to the master document. All rows have a unique code number that links th...
if you created relationship between two tables you can try this
Column = if(RELATED('Table 2'[Risk description change])="",'Table 1'[Risk description],RELATED('Table 2'[Risk description change]))if don't have the relationship, you can try thisColumn 2 =var _update=maxx(FILTER('Table 2','Table 1'[Risk ID]='Table 2'[Risk ID ]),'Table 2'[Risk description change])return if(_update="",'Table 1'[Risk description],_update)pls see the attachment belowyou are welcome
Sorry this just gives lots of errors. Can you recommend a DAX code?
if you created relationship between two tables you can try this
Column = if(RELATED('Table 2'[Risk description change])="",'Table 1'[Risk description],RELATED('Table 2'[Risk description change]))
if don't have the relationship, you can try this
Column 2 =
var _update=maxx(FILTER('Table 2','Table 1'[Risk ID]='Table 2'[Risk ID ]),'Table 2'[Risk description change])
return if(_update="",'Table 1'[Risk description],_update)
pls see the attachment below
This works great-thank you
you are welcome