Skip to main content

Power BI

Needs Votes

Provide Mask Capability for 'formatting' Alpha Numeric Fields

Vote (2) Share
Timothy Stepp's profile image

Timothy Stepp on 23 Oct 2020 19:06:57

I have some large tables with unmasked A/N fields. For user readability, i need to be able to Mask a field with a character like '-' or '/'. Adding a formatted calculated column can be 'expensive'. For example. Would like to be able to take a field such as '1234BA78099' and display as '1234BA-78-099'.