Category: Power Pivot

5 Ways To Change Text Case In Excel

by John | Apr 30, 2019 | DAX, Functions, Power Pivot, Power Query, Tutorials | 0 |

Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.

Read More

Summarizing Text Data With Pivot Tables

by John | Jan 13, 2019 | DAX, Pivot Tables, Power Pivot | 5 |

Learn how to summarize text data in the values area of a pivot table using the data model and DAX formulas.

Read More

Follow

Consulting

Newsletter

Excel Functions eBook

Microsoft MVP

Categories

Recent Posts

5 Ways To Get The Weekday Name From A Date
Nov 13, 2019 | Tutorials
Everything You Need To Know About XLOOKUP
Sep 24, 2019 | Functions
The Complete Guide To Slicers And Timelines In Microsoft Excel
Aug 12, 2019 | Pivot Tables, Tutorials
7 Ways To Find And Remove Duplicate Values In Microsoft Excel
Jul 13, 2019 | General, Tutorials
The Complete Guide To Microsoft PowerApps
Jul 5, 2019 | PowerApps, Tutorials

Advertisement

Newsletter

Pin It on Pinterest