Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Dear Community,
I hope you can help me. I need to create a calculated column to identyfy the lines with a 6 digit number in the text.
Is there a function to identify the notifictn(unic number) that has a 6 digit number in the material text(placed at different positions and with different 6 digit numbers)?
Hi @gjelstrup
Please test the following. I did not have the chance to test from my side.
6 digit number =
VAR String = 'Table'[Material Description]
VAR Items =
SUBSTITUTE ( String, " ", "|" )
VAR Length1 =
COALESCE ( PATHLENGTH ( Items ), 1 )
VAR T1 =
GENERATESERIES ( 1, Length1, 1 )
VAR T2 =
SELECTCOLUMNS ( T1, "@Item1", PATHITEM ( Items, [Value] ) )
VAR T3 =
FILTER (
T2,
VAR Item1 =
COALESCE ( [@Item1], 1 )
VAR Length2 =
LEN ( Item1 )
VAR T4 =
GENERATESERIES ( 1, Length2, 1 )
VAR T5 =
SELECTCOLUMNS ( T4, "@Item2", MID ( Item1, 1, [Value] ) )
VAR T6 =
GENERATESERIES ( 0, 10, 1 )
RETURN
LEN ( Item1 ) = 6
&& ISEMPTY ( EXCEPT ( T5, T6 ) )
)
RETURN
MAXX ( T3, [@Item] )
Hi @tamerj1 I really apprecialte your help. Thank you.
I cannot make it Work. I think that I need to change what is marked by ned in below scrren dump, however, I am not certain what I need to change it to.
Yes, this is a typo mistake, the price paid for not testing. It should be [@Item2]
Apologies again. It should be [@Item1]
Sorry, im really new to this BI stuff, where are you putting this code, in a measure or a new column?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
22 | |
21 | |
19 | |
13 | |
12 |
User | Count |
---|---|
41 | |
32 | |
23 | |
22 | |
22 |