Create a column that is the value of a different column, based off conditions of other columns

[Anonymous]

I have a Date column, and 2 other columns with 0 and 1s. I would like to create another date column but it only has a Date if the other 2 columns are contain a 1.

[tackytechtom · Accepted solution]

Hi @Anonymous 

Do you mean, something like this? 🙂

calculated column =
IF ( 'table'[column1] = 1 && 'table'[column2] = 1, 'table'[date], BLANK() )

Let me know if this helps! 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/