• Skip to main content
  • Skip to footer

Curbal

Learn how to grow your business with your data and Power BI

  • Resources
    • DAX Glossary
    • Download Center
    • Template Apps
    • Data Stories Gallery
    • Solution Gallery
    • Learning Resources
  • Courses
    • Introduction to Power BI – FREE Online course
    • Power Query Online Training for Power BI
    • M Language Online Course: The unofficial and Practical Reference Guide
  • Blog
  • Shop
    • Courses
    • Swag
    • Template Apps
    • Donations
  • Cart
  • Register/ Log In
    • Become a Member
    • Log In
    • My account
    • My Courses
  • Contact
You are here: Home / CM Tooltip Glossary Pro+ / FIND

FIND

posted on October 2, 2017

« Back to Glossary Index

Syntax

FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])

In today’s DAX Fridays! tutorial we are going to go though examples on how to use two DAX functions: SEARCH and FIND SEARCH and FIND DAX functions are used to find the number of characters at which a specific word is found in a column.

Keynotes:

00:58 SEARCH function DAX Microsoft Documentation
02:20 DAX search function without options
04:00 DAX search function with options
04:43 DAX search function Error validation options
05:49 DAX search function with * wildcard
07:00 DAX search function with ? wildcard
08:52 Search and Switch functions
10:35 Find function DAX Microsoft Documentation
10:57 Find function explained
11:32 Find vs Search function

Download example file:

Link to Power BI file: here.

Remarks

Whereas Microsoft Excel has multiple versions of the FIND function to accommodate single-byte character set (SBCS) and double-byte character set (DBCS) languages, DAX uses Unicode and counts each character the same way; therefore, you do not need to use a different version depending on the character type.

This DAX function may return different results when used in a model that is deployed and then queried in DirectQuery mode. For more information about semantic differences in DirectQuery mode, see http://go.microsoft.com/fwlink/?LinkId=219171.

Was this helpful?
[Total: 3   Average: 3.3/5]
Related Articles:
  • Download Center
  • Google Analytics Template App by Curbal
  • How engaging is your website content? Discover it with Power BI and Google Analytics
  • How to effectively tell a story with data and Power BI
  • Identify and Remove referrer spam from Google Analytics using Power BI
See Also:
  • AVERAGE
  • CONTAINSSTRING
  • CONTAINSSTRINGEXACT
  • COUNTA
  • KEEPFILTERS
« Back to Index

Reader Interactions

Let us know your thoughts... Cancel reply

Footer CTA

Join our community of +20,000 professionals

Become a Member

Subscribe to YouTube

About us

Curbal AB
Kopparbergsvägen, 10
722 13 – Västerås
Sweden

OrgNo: 5569680852 | VAT: SE556968085201

 

Location:

© Copyright 2014-2021 · Curbal AB · All Rights Reserved · Privacy Policy · Terms of Service · Refund Policy · Log In