Forum Discussion

Kreg's avatar
Kreg
Helper I
3 years ago

Query to work with numbers

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.

 

 

Need Help

3 Replies

  • Kreg's avatar
    Kreg
    Helper I
    3 years ago

    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).