The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Can anyone tell what is the issue in this formula?
Trying to extract the numbers then after looking at the first digit assign valid or invalid status
using it in custom column in editor
if (Text.Start(Text.Select([StoreCode], {"0".."9"})) ) = 5 then "Valid" else "Not Valid"
Solved! Go to Solution.
Text.Start takes 2 parameters.
5 is not a text value.
That's my initial thoughts.
Break it down to get it working, then build it back up
Tried "5" as well nothing changed.
Formula isn't showing any error in syntax but when I apply it says
Expression.Error: 1 arguments were passed to a function which expects 2.
Details:
Pattern=
Arguments=[List]
Text.Start takes 2 parameters.
5 is not a text value.
That's my initial thoughts.
Break it down to get it working, then build it back up
Yes i was missing the second parameter of count.
User | Count |
---|---|
15 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
23 | |
14 | |
13 | |
8 | |
8 |