Pardaan.com

If your work becomes your passion…

If your work becomes your passion…

Menu

  • Profile
  • Tags

Categories

  • Data & Analysis (245)
  • Dynamics NAV (4,734)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (4,556)
  • ERP general (347)
  • Information management (58)
  • Off-topic (45)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

Populair

  • Why is my system slow? Performance and Dynamics NAV 6.5k views
  • MS Project basishandleiding 6k views
  • Microsoft Dynamics NAV: Copy Table Data from one Company to another Company 5.9k views
  • Using REST/Json web services from NAV 5.8k views
  • How to Determine Who Has a Table Locked in Microsoft Dynamics NAV 5.7k views
  • The metadata object Table 0 was not found error 5.4k views
  • Call external web service using new CU 1290 4.9k views
  • How to print barcodes on a Microsoft Dynamics NAV report 4.7k views
  • Setting default Printer Selections in NAV 4.7k views
  • Microsoft Dynamics NAV How To: Override the ‘5000’ Limit When Exporting Using Microsoft Excel 4.5k views

Removing Punctuation From Text With The Text.Select M Function In Power BI/Power Query/Excel Get&Transform

By admin in Data & Analysis 20 December 2017

A new, as-yet undocumented, M function appeared in the December 2017 release of Power BI Desktop (I assume it will appear in Excel soon): Text.Select. Here’s the documentation from the Query Editor:

Bron : Chris Webb’s BI Blog
Lees meer…

Share this:

  • Facebook
  • LinkedIn
  • WhatsApp
  • Twitter
  • Email
  • Print

Like this:

Like Loading...

Gerelateerde artikelen:

  1. Removing HTML Tags From Text In Power Query/Power BI
  2. The Text.Format() Function In Power BI/Power Query M
  3. Splitting Text By Character Transition In Power BI And Excel Power Query
  4. How To Tell Whether Query Folding Is Taking Place When Importing Data From Analysis Services In Power BI And Excel Power Query
  5. An M Function To Help You Explore Power Query Diagnostics Data
Tags FunctionMPower BIText.Select
Using Placeholders in NAV Reports
New COMPANYPROPERTY function in NAV 2018

Related Articles.

Analyzing Dynamics 365 Business Central telemetry with Power BI

03 Mar, 2021

Implementing Data (As Well As Metadata) Translations In Power BI

03 Mar, 2021

Using Power BI Dynamic M Parameters In DAX Queries

17 Dec, 2020

Delaying Power BI Dataset Refresh Until The Source Data Is Ready

03 Dec, 2020

Handling Multi-select In Power BI Dynamic M Parameters

26 Nov, 2020

If your work becomes your passion…

Pardaan.com

Microsoft Dynamics NAV, Business Central, ERP general, Projectmanagement, Information management and Visual C#

Cornator

  • 1,017
  • 1,139
  • 32,688
  • 487,589

Facebook pagina

Facebook pagina
Dennis Pardaan

Start with Why

Stay Hungry, Stay Foolish

RSS Mibuso

  • Add filter on request page on report
  • Intercompany Transaction Add-Ons in NAV
  • Salesconfirmation as E-mail, want non-modal mode
  • Install apps from MarketPlace on on-premises environments
  • New Workflow Event
  • Returning Multiple Value on ODATAv4
  • SSRS report to PDF
  • Odata Service Reference
  • Save report as pdf and send as e-mail
  • Post image into Business Central via API page
  • sales price discounted by an amount between level parametre
  • List of all published extensions from AL Code
  • AL(AS0085) Warning Message
  • Retrieve data from XML file
  • Export File to Azure Storage Location
  • Proforma Invoice
  • Error in Invoke-NAVApplicationDatabaseConversion for Azure SQL
  • UnitPrice in sales line
  • How to add Chart in Role Centre Page
  • Permissions Dialog for Interacting with External Functionality

RSS Dynamics NAV Team Blog

  • Extending reports in Business Central
  • New features personalize customer experiences in Dynamics 365 Customer Voice
  • Customize your protection with new features in the Dynamics 365 Fraud Protection preview
  • Architecting resiliency in supply chains with Microsoft Dynamics 365
  • Get real-time digital analytics with Dynamics 365 Customer Insights
  • Discover the latest innovations for Dynamics 365 Business Central
  • Transforming manufacturing operations with Dynamics 365 Remote Assist
  • Navigating the skills gap with Dynamics 365 Guides
  • Knowledge management enhancements increase agent efficiency
  • Host web apps using Microsoft Edge WebView2 Process in Unified Service Desk (Preview)

RSS Power BI

  • Announcing the new Power Automate visual for Power BI reports
  • Announcing the new Charticulator visual (Public Preview)
  • Join us! Power BI Summit April 19-23
  • Object-Level Security (OLS) is now generally available in Power BI Premium and Pro!
  • New sharing experience coming soon!
  • What’s New In Dataflows – April 2021
  • Power BI Premium per user now generally available for purchase
  • Announcing new deployment pipelines capabilities
  • Announcing Power BI inheritance of MIP labels from Azure Synapse Analytics (Public Preview)
  • Guide to enabling your organization to use Power BI in Microsoft Teams
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
loading Cancel
Post was not sent - check your email addresses!
Email check failed, please try again
Sorry, your blog cannot share posts by email.
%d bloggers like this: