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

  • Get & Append Data From GOOGLE SHEETS and MICROSOFT ACCESS to Create Excel PivotTable Report
  • Dynamic FILTER BETWEEN YEARS using Power Query and Data Validation
  • Merry Christmas in Random Font Colors
  • CONDITIONALFORMATTING Custom Function using XLOOKUP & LAMBDA Functions
  • SUMBETWEENMONTH Custom Function using SUMIFS | LET | LAMBDA Functions
  • TEXTSPLIT Custom Function using New LAMBDA Function
  • Spearman’s Rank Correlation Coefficient in Excel with Geography Data Type
  • New Auto-expand Drop-down List Technique in Excel
  • Stunning Stacked Column Chart with Heart
  • Send Bulk Email in Excel using Power Automate
  • Cross Tabular Report using VLOOKUP Function
  • 5 Keyboard Shortcuts To Format Data As Excel Tables
  • Power Query Data Types [The Game Changer]
  • VLOOKUP with Array Constants
  • DAX Calculated Column with IF Statement

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme