Pardaan.com

If your work becomes your passion…

If your work becomes your passion…

Menu

  • Profile
  • Tags

Categories

  • Data & Analysis (248)
  • Dynamics NAV & BC (5,356)
    • Functional (119)
    • General (116)
    • Technical (48)
    • Tips & tricks (5,177)
  • ERP general (347)
  • Information management (58)
  • Off-topic (51)
  • Projectmanagement (450)
  • Quote of the week (29)
  • Visual C# / ASP.net (57)

The Text.Format() Function In Power BI/Power Query M

By admin in Data & Analysis 5 January 2016

New functions are appearing in M all the time, many with no announcement or documentation. I came across Text.Format() the other day and I thought it was worth blogging about because I can see a lot of uses for it: it makes it very easy to insert values into a piece of text.

Bron : Chris Webb’s BI Blog
Lees meer…

Share this:

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

Like this:

Like Loading...

Gerelateerde artikelen:

  1. Removing Punctuation From Text With The Text.Select M Function In Power BI/Power Query/Excel Get&Transform
  2. Removing HTML Tags From Text In Power Query/Power BI
  3. Splitting Text By Character Transition In Power BI And Excel Power Query
  4. Rendering Text On A Map With Power Query And Power Map
  5. Using Text.BetweenDelimiters() To Extract URLs From A Web Page In Power BI/Power Query M
Tags FormatFunctionPower BIQueryText
Using the Company “System Indicator”
How do I: Set Up Rounding Rules for the LCY

Related Articles.

Text splitting and formatting using Lists

27 Jan, 2023

Creating Power BI Reports for Displaying List Data in Dynamics 365 Business Central (Filter the Power BI report based on the selected record)

12 Dec, 2022

Calling Azure Functions from AL (new in Business Central 2022 Wave 2)

23 Nov, 2022

Connect to Azure Function in BC 2022 wave 2 (v21)

26 Oct, 2022

Can I query half a record in AL?

12 Oct, 2022
Pardaan.com

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


Dennis Pardaan

Facebook page

Facebook page

Stay Hungry, Stay Foolish

RSS Mibuso

  • How to handle VAT for free of cost invoices - NAV 2017
  • AL code for reporting Lot by BIN
  • XMLport import XML doesnt work when xmlns attribute within XML root in BC
  • How to move cursor to the new line in BC
  • "The date is not valid"
  • Trigger something into another Company
  • How to find out the date based on day, weekno of month ,month and year
  • Determine the page that begun the call stack
  • List type pages not showing data on phone client running on Chrome browser
  • Having a Posting Problem with too many Direct Cost entries in Business Central SaaS
  • Error when posting Sales Order, if not CodeUnit.Run(), BC Cloud.
  • Error in page filters, only a user of 200
  • SQL error when Adjust Cost runs.
  • Custom Workflow Approval process question
  • Cant download Symbol from C/AL in AL
  • How to Put a Exported XML file from Xmlport to Azure Blob Container in BC 365 AL
  • Can you change option value based on a condition?
  • SQL Database size
  • Cancel payment to vendor
  • Business central installation

RSS Dynamics NAV Team Blog

  • Finance Reimagined: Microsoft uses low-code and automation to streamline processes
  • Create a Digital Contact Center in seconds with the Customer Service free trial
  • 2023 release wave 1 plans for Microsoft Dynamics 365 and Power Platform now available
  • Optimize Dynamics 365 Sales product usage with new reports!
  • 5 customer service trends to watch in 2023
  • Optimize sales conversation follow-ups in two easy steps
  • Warehousing telemetry now available in Supply Chain Management
  • The Microsoft Supply Chain Platform enables resiliency for retailers
  • The data bias challenge: Creating inclusive customer experiences
  • Transform retail customer experiences with the Microsoft Customer Experience Platform

RSS Power BI

  • Power BI Datamart – January 2023 Feature Summary
  • Power BI Report Server January 2023 Feature Summary
  • Building Multi-language Reports for Power BI in 2023
  • Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings
  • Announcing backup and restore improvements for large datasets near the size limit
  • Announcing Connected Excel Tables from Power BI (Public Preview)
  • Announcing My workspace governance improvement (Public Preview)
  • Announcing the Public Preview of Power BI Dataset Scale-Out
  • On-premises data gateway December release
  • Announcing Power BI in Microsoft Teams collaboration experiences improvements
Proudly powered by WordPress. Theme: DW Minion by DesignWall.
%d bloggers like this: