Mini-Post 3/4: DAX.xml Update for Notepad++ from Colin Banfield

Kristi Cantor

Kristi Cantor is a business intelligence, analytics, and AI practitioner with hands-on experience in Power BI, business intelligence strategy, data analytics, and practical AI adoption. At P3 Adaptive, she works extensively with modern AI tools and emerging business applications, helping explore how technologies like Microsoft Copilot, generative AI, and analytics automation reshape decision-making. As Digital Content Manager, she combines real-world technical experience with strategic communication to create authoritative content on Power BI, Microsoft Fabric, AI strategy, business intelligence, and modern data platforms.

(Rob’s note:  Apologies to Colin, he put this up here in draft form weeks ago and even though I promised to flip it to live two weeks back, I forgot.  So Colin…  a thousand pardons.  This is awesome!)

From Colin:

For those of you that use DAX.xml with Notepad++, there is an update available at https://powerpivotfaq.com/PowerPivot%20Samples/Forms/AllItems.aspx. There is also an update of the DAX functions file. Although I created the new files shortly after downloading the Denali version of PowerPivot, I held off making the files available because, at the time,  I didn’t know whether any additional functions would be added in the final release. I have it on good authority that no additional functionality will be added on top of CTP3, so it’s unlikely that the files will change between now and PowerPivot V2 RTM. Note that the list of functions contains those that are not currently documented, including the very important KEEPFILTERS function, which you can read about in this superb post from Alberto Ferrari. Perhaps this function should have been called KEEPUSERSIGNORANT (okay, just kidding Smile).

If you missed the Notepad++ post, and might be interested in using this excellent tool to author your DAX measures, you can read the original post here.

Kristi Cantor

Kristi Cantor is a business intelligence, analytics, and AI practitioner with hands-on experience in Power BI, business intelligence strategy, data analytics, and practical AI adoption. At P3 Adaptive, she works extensively with modern AI tools and emerging business applications, helping explore how technologies like Microsoft Copilot, generative AI, and analytics automation reshape decision-making. As Digital Content Manager, she combines real-world technical experience with strategic communication to create authoritative content on Power BI, Microsoft Fabric, AI strategy, business intelligence, and modern data platforms.

Read more on our blog

Get in touch with a P3 team member

  • This field is for validation purposes and should be left unchanged.
  • This field is hidden when viewing the form
  • This field is hidden when viewing the form

This field is for validation purposes and should be left unchanged.

Related Content

What Are The Best AI Features To Use In Power BI

Power BI’s AI capabilities can go underused when teams don’t know which

Read the Blog

Power BI Development & Custom Dashboard Services

Off-the-shelf dashboards often fall short of what a business actually needs to

Read the Blog

When Is It Time To Outsource Power BI Dashboard Building vs. Doing It Yourself?

Deciding whether to build your own Power BI dashboards or bring in

Read the Blog

What Should I Include In A BI Dashboard?

Building a BI dashboard without a clear plan often leads to cluttered

Read the Blog