Query to work with numbers

[Kreg]

Hi,

I have a column where I want to see only numbers without zeros at the beginning.

For example there are data in Column

Showroom ID   |      car model    |    delivery date   |     sell date     |   time in showroom

00123456         |      Torro 2         |    04/14/2023     |    05/12/2023 |   ???

T987898           |      Torro B         |    04/29/2023     |    06/01/2023 |   ???

Torro:98123      |     Torro B          |    05/20/2023     |                       |    until today

458923             |       Torro E         |    05/10/2023    |                       |    until  today

Could some help with resolving those questions?

1. I need to have only numbers in Showroow ID column, so zero at the beginning, all text, some sign must be cutted, only numbers like in fourth row. I would like to catch it with some query from main view.

2. Next, I would like to see the days spend in the showroom, so from `delivery date` to `sell date` in `time in showroom` column. Also if it is still in showroow it should counts from `delivery date`  to current date.

[Kreg]

Anyone could take a look on that? 

[Kreg]

Thanks Ahmedx, but can you provide the solution with query in DAX? I mean not from the Transform data section, since I do not want to hide some of those data permanently. Some times I there must be useful to me take a look what data are in the - . I mean user can put the - instead of showroom ID, still there are some data there, so still I need to have it easily disable query to see what is going on.

And still the second question, which I forgot in first post thread to finish (it cutted text).

[Ahmedx]

pls see me video

https://1drv.ms/v/s!AiUZ0Ws7G26RiE3KJf6KVikypPXa?e=DSPZtc

(x) => Text.Select(x,{"1".."9"})