Forum Discussion
Solved
Check for value
date home away 17.10.2018 a f 18.10.2018 a b 19.10.2018 f c I want to create a new calculate column to check whether a value in 'home' column is present in either 'home' co...
sorry, it was my bad
Column = var _playedYesterday = countrows(filter('Table','Table'[date]=EARLIER('Table'[date])-1 && ('Table'[home]=EARLIER('Table'[away]) || 'Table'[home]=EARLIER('Table'[home])))) return if(_playedYesterday>0,"yes","no")should be correct for back-to-back games for home team
I love sports stats! 🙂
sorry, it was my bad
Column =
var _playedYesterday = countrows(filter('Table','Table'[date]=EARLIER('Table'[date])-1 && ('Table'[home]=EARLIER('Table'[away]) || 'Table'[home]=EARLIER('Table'[home]))))
return
if(_playedYesterday>0,"yes","no")
should be correct for back-to-back games for home team
I love sports stats! 🙂
