Forum Discussion
Create an if statement in a measure that returns both text and a column field
Totally new to Power BI and just can't get my head around this !! I want to create a Measure that uses an if statement in my Model Table. I can write the if statement ok I just want to return a co...
figured this out. I created a new column within the data environment and used the following syntax (which I guess was the problem all along !!.
= if('Table1'[Field1]='Table1'[Field2],"OK","Check - "&'Table1'[Field1]&" vs "&'Table1'[Field2])
Thanks for all your time and patience. As always, much appreciated.
figured this out. I created a new column within the data environment and used the following syntax (which I guess was the problem all along !!.
= if('Table1'[Field1]='Table1'[Field2],"OK","Check - "&'Table1'[Field1]&" vs "&'Table1'[Field2])
Thanks for all your time and patience. As always, much appreciated.
Thanks for all your time and patience. As always, much appreciated.