Conditional format formula

[Anonymous]

Hello, Im a new user on Power BI ... trying to get familiarize.

We have an issue while creating a column, a value is getting trimmed from the source.

Instead of showing the full number, the source is showing a trimmed value starting with an *.

What type of formula can I use to catch any value that start with an * ? so far we havent been able to figure it out.

[ribisht17 · Accepted solution]

@Anonymous 

This variable can catch * for you

LEFT(Table[Column]), 1) = "*"

In other words,

IF( LEFT(Table[column]),1)="*","Corrupt","Fine")

Ritesh