The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to Solution.
@Anonymous
This variable can catch * for you
LEFT(Table[Column]), 1) = "*"
In other words,
IF( LEFT(Table[column]),1)="*","Corrupt","Fine")
Ritesh
@Anonymous
This variable can catch * for you
LEFT(Table[Column]), 1) = "*"
In other words,
IF( LEFT(Table[column]),1)="*","Corrupt","Fine")
Ritesh