I having issue to "search" for specific text when I use IF faction at Dax.
I have the next code:
=IF([TesterName]="G1", IF([status] = 'Active',[status],[status]))
that should search for "G1" under "TesterName" column.
My problem is that at Testername column data is XXXXG1, CCCCCG1...