Forum Discussion
Solved
Comparing values in a column and outputting a string
Hi, So I have a matrix and need to compare two columns and return a string. The 1's are basically a distinct count of a part number on a certain extraction date. So I want to compare betwe...
Hi SK456
I have a new idea for this thread. Please download my pbix file to see if it can meet your need.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi,
Use the below code to create the new Column :
Status = if (Sheet20[Col1] = Sheet20[Col2], "No Change",
if ( ISBLANK(Sheet20[Col1]) && Sheet20[Col2] = 1, "New",
if( Sheet20[Col1] = 1 && ISBLANK(Sheet20[Col2]), "Removed")
)
)