Category Archives: PowerPivot DAX

#Excel Super Links #44 – shared by David Hager

Excel Formulas Can Make a Graph

2D non-linear FEA with Excel

Generating Permutations in Excel

Excel Magic Trick 1427: DAX GEOMEANX function: Average Compounding Rate per Period for FV Calc

Copy #Excel Chart as a Enhanced Metafile Picture by David Hager

#Excel Super Links #43 – shared by David Hager

Dynamic format using DAX

Dynamic CAGR Calculation in DAX

Animated Asynchronous Electric Mmotor Model in Excel

Excel Monthly Report Tutorial

Copy #Excel Chart as an Enhanced Metafile Picture by David Hager


#Excel Super Links #41 – shared by David Hager

Excel High Precision Engineering Chart #1

Power Query (M)agic Part 1: Always Have Good References

Exposing System Secrets with VBA and WMI API

Determining The Drive Type From Excel

Creating a Unique Delimited String from an Excel Filtered List by Using the TEXTJOIN Function By David Hager


#Excel Super Links #39 – shared by David Hager

VLOOKUP: List all the Matching Items

VLOOKUP Across Several Worksheets (2) – Multiple Search Criteria

VLOOKUP vs INDEX-MATCH. Which is better?

Parameter Table in DAX

#Excel: Modifying Control Chart Data to Remove Outliers with Excel Formulas 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 #35 – shared by David Hager

Excel Code Cracker Game

Excel VBA convert column of sentences to column of single words

Excel Magic Trick 1419: RANKX DAX Function & More: Ranking Profit for Products within Manufacturer

=SUM(‘???’!C3) Is it a valid formula?? No. It is magical indeed!

Averaging of Scientific Results in Excel