Category Archives: Power BI

#Excel Super Links #42 – shared by David Hager

Creating Infographics with Excel, Part 1

Web Scraping Power BI Custom Visuals from Office Store

Grid of Random Integers in Excel

How to edit M-function Documentation Metadata

#Excel: Four Super Filter Techniques by David Hager

#Excel Super Links #38 – shared by David Hager

100 Excel Tips & Resources to Celebrate 2000 RSS Subscribers

Power BI Desktop/DAX – Using Unicode (Arrows) as Measures in a Table

Reverse two-way Lookup in a Cross Reference Table

The Excel VBA Code Cleaner

#Excel For You Blog Posts Containing Downloadable Workbook Files by David Hager


Generating Random Initials with DAX in Power BI by David Hager

After publishing a short article about generating random initials in Excel

I wanted to see if the same formula worked in Power BI. When I entered the aforementioned formula into a calculated column in Power BI desktop, I got an error message. After some research, I discovered that was no CHAR function in the DAX function reference. Then, I remembered that Chris Webb showed examples of the new UNICHAR function at the following link.

And, Chris discovered that the UNICHAR function was completely undocumented and was probably introduced in the April 2017 update. So, I changed my random initials formula using UNICHAR instead of CHAR, and it worked.


Now, you can use this in your Power BI projects.

It is still a mystery how DAX could be around for 8 years and not have the CHAR function (or its equivalent).


#Excel Super Links #37 – shared by David Hager

PivotTables Just Got Personal

Dynamic distances in Power BI

Filter a BI report with a URL query string parameter

Excel XML – Dynamic Periodic Table

#Excel Short and Sweet Tip #12 (Documenting Formulas and Highlighting Those Formulas With Conditional Formatting) by David Hager


#Excel Super Links #36 – shared by David Hager

Interactive Bullet Graphs in Excel

The Ultimate Guide to Slopegraphs in Excel

An Index of Excel Tips

Performance difference between Excel and PowerBI with M is huge!

#Excel: Finding and Visualizing the Last Record in a Table Based on Criteria by David Hager


#Excel Super Links #34 – shared by David Hager

SUMIFS Formula With Empty Criteria Cells

Tip – Create several AutoSum Measures in with one click #Excel Power Pivot – #powerbi

Interpolate values using the FORECAST function

Excel Magic Trick 1415: Power Query Lookup and Return Multiple Items And Join Them In Single Cell

Excel 2013: Power Query OmniQueries. Dynamic And Refreshable Connections To The Data Model


#Excel Super Links #33 – shared by David Hager

How to Use Microsoft Excel Fuzzy Lookup Add-in

Use VBA to automate Power Query in Excel 2016

Old Japanese Man Creates Amazing Art Using Excel (Wait, Excel?)

SUMX() – The 5-point Palm, Exploding fxn Technique

TEXTJOIN: Multiple Lookup Values in a Single Cell (With/Without Duplicates) Using Only #Excel Formulas by David Hager