Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hi,
I have loads of notifications in where has been reported added oil in (desi)litres along with some other text. Here are some examples of the data I have (Notification) and two colums I'd like to have.
| Notification | Oil added | For calculation |
| Added DTE25 0,5l | 0,5l | 0,5 |
| Added 0,5l DTE25 | 0,5l | 0,5 |
| 5 dl of DTE25 added | 5dl | 0,5 |
| 0,5 litres of DTE25 added | 0,5l | 0,5 |
| 5 desilitres of oil added | 5dl | 0,5 |
| Added 200 l oil | 200l | 200 |
Basically I'd like to search for combination of any amount of numbers (might or might not include comma) with l or dl or litres or desilitres with or without space between the numbers and the text. Is there any way this can be done?
-Anssi
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 13 | |
| 10 | |
| 10 |