Huge amount of DAX formula templates now in Analyst Hub

sam.mckay · February 9, 2021, 9:37pm

Check out the Analyst Hub community…

We’ve been adding a huge amount of templates for DAX formulas that we are locating and sourcing from around the internet.

We want to cover every formula you could ever use in Power BI.

Plenty more announcements coming soon around AH. 4 brand new apps being released over the next 4 weeks!

Sam

sam.mckay · February 10, 2021, 11:05pm

Almost 250 DAX formula patterns and templates…with more to come.

Keep adding to this everyone, whenever you come up with anything.

Also don’t forget to save down your fav. patterns inside your own personal documents

Sam

Tibbie · February 15, 2021, 1:42pm

Hi @sam.mckay,
Where can I read about the differences between beeing a paying member of the “Enterprise DNA Membership” and also pay for the “Analyst Hub” ? What are the differences between each “product/service” ?

EnterpriseDNA · February 22, 2021, 1:15am

Hi @Tibbie! Enterprise DNA Membership is solely for Power BI training. This includes access to training videos, resources, webinars, and access to Enterprise DNA Forum. While Analyst Hub is web-based application designed to support Power BI development and deployment.

With the Analyst Hub, you may gain access to a pool of applications that could help you and your team create and collaborate on the reports and dashboards you’re making. These two requires separate subscription. To see what plans are available for Analyst Hub, you may check - https://enterprisedna.co/analyst-hub-home/

Tibbie · February 22, 2021, 8:56am

Okey @EnterpriseDNA
I was just curious since the words Sam used “Huge amount of DAX formula templates” could be seen as resources Enterprise DNA Membership

Matthias · February 22, 2021, 3:04pm

Could you add an “alphabetic” sort order?

Potentially there are some duplicates included, respectively some of the entries might need a more differentiating description:
Creating Financial Calendar - Decoding Date and Calendar 1-5
Ranking
Phone Number Verifier
Compound Annual Growth Rate
Dynamic Measures/Titles (Using Parameter Table)
Running total performance measure

sam.mckay · February 23, 2021, 3:46am

At moment no way to sort in order.

We have set things up, where you can easily copy a formula, change the title, description, actual formula to whatever you like.

Save it for yourself or even save the updated one in the community. It’s very flexible with many options to use or extend the templates.

Good luck!

Sam

Matthias · February 23, 2021, 11:13am

Thanks Sam!
So you recommend to create your own collection. I assume that with the growing number of formulas in the community collection it would get more and more difficult to make sure that there are no duplicates respectively ensure that the formula name is showing the difference.

Cheers,
Matthias

sam.mckay · February 23, 2021, 9:46pm

Personally, I’ve never been worried about duplication in the community area. The community is a way to collect every variation on any type of doc, and then individual users can leverage of them to create their own customized collections.

That’s always been my intention ever since dreaming up the Analyst Hub

Sam

sam.mckay · February 23, 2021, 9:47pm

We might look to periodically clean up this space but will see how it evolves over time.

Sam

EnterpriseDNA · March 1, 2021, 12:53am

This post is part of the Enterprise DNA platform initiative to provide varied information. To ask any questions on the content covered in this category please start a new topic within the forum. You may check this how-to guide for reference - How To Use The Enterprise DNA Support Forum

Latest Enterprise DNA Initiatives

Huge amount of DAX formula templates now in Analyst Hub