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: Excel Data Model

Alternative To Power BI COALESCE DAX Function In Excel Data Model

Posted on April 19, 2020April 20, 2020 by Abiola David | No Comments

Welcome to Excel Jet Consut blog post. In my previous post on COALESCE DAX Function in Power BI, I show us how to use COALESCE DAX Function which returns scalar value coming from one of the expressions or BLANK if all expressions evaluate to BLANK. In this tutorial, we are going to learn how to fill blank rows with value […]

Continue reading→

Blog Posts

  • Calculator in Excel VBA (User Interface Design) Part One
  • Linear Equation Computation and Graph in Excel
  • 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]

Copyright 2019 © Excel Jet Consult. All Rights Reserved

A SiteOrigin Theme