Skip to content
Data Analytics Logo
  • Home
  • About Us
  • Course Portfolio
    • Microsoft Excel for Professionals
    • Microsoft Excel Advanced Master Class
    • Power BI
  • Blog
  • Photo Gallery
  • Register
  • Menu

Tag Archives: DAX

Extract Leftmost and Rightmost Names using PQ M Functions

Posted on December 15, 2019December 15, 2019 by Abiola David | No Comments

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to use the Power Query M Function to extract First and Last Name from Full Name. Let’s get started In the caption below, I have simple data in my Power Query. I want to extract the leftmost names i.e Phoebe, Tina Abiola etc to be my […]

Continue reading→

Blog Posts

  • Convert Numbers to Proper Time Format in Power Query
  • Transform Report to Dataset using Power Query
  • Combining TEXTBEFORE & TEXTAFTER Function with SUMIFS in Excel
  • APPEND Data From Multiple Sheets & Get Total Row using VSTACK & HSTACK
  • Brand New TEXTSPLIT, TEXTAFTER & TEXTBEFORE Functions
  • How SWITCH Function will make you the “Go-to Person”
  • Dynamic Array FILTER by Month & Quarter
  • ADVANCED Filter Super Trick to Reorder Entire Columns without Criteria
  • 3 Hidden Tips & Tricks You Probably Don’t Know About ADVANCED Filter
  • Author LAMBDA Custom Function using New Advanced Formula Editor
  • Calculate Sales Commission for Weekdays & Weekends using Power Query M Code
  • New Automatic Searchable Dropdown in Excel [No More Formula-Based Solution]
  • Conditional Formatting using XLOOKUP and FILTERS Functions in Excel for the Web
  • Create Workbooks from Worksheets using VBA
  • Power Query Classic COUNTIFS | SUMIFS | AVERAGEIFS | MAXIFS | MINIFS Calculations [Simply Amazing]

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme