Ciao friends, I want to take a few minutes to summarize
what happened in the world of DAX in 2021,
and spoil something about 2022.
So, what happened in 2021?
DAX received minor updates,
even though Microsoft has done much work on the new composite models.
Yes, the "DirectQuery for Power BI datasets and Analysis Services"
feature that we all call composite models - that one!
The function CALCULATE
simplifies the syntax
to write filters involving multiple columns,
and this is helping a lot people that are newbies in DAX.
You can also set the DetailRows Expression property in
Power BI Desktop models to improve the
drillthrough experience in Excel PivotTables.
When you use Analyze in Excel.
For sure, the biggest news of
the year is the release of Tabular Editor 3.
Yes, if you want the best
DAX editor in the world, maybe in the universe,
you have to get an external Tool. Right or wrong,
it is what it is.
If you value productivity, using Tabular Editor 3 is a no-brainer,
considering that the integrated DAX debugger
feature is coming soon in 2022.
Preview in January, probably.
So what about SQLBI?
We surpassed 40,000
subscribers on our YouTube channel, producing a video
for each DAX function published on the DAX Guide website
and improving the connections between articles
and videos. Articles on SQLBI.com and videos on YouTube.
Yes, we still write articles
and we send a newsletter every other week.
We have done that for more than 200 times now, and we celebrated
the 200th issue with the vintage layout of the very first one!
You can take a look on the website if you want.
Oh, did I mention we released a new course?
Mastering Tabular has 35 hours
of training with all you need to create an enterprise level solution
based on Power BI and/or Analysis Services.
Just some advertising, right?
But what's next?
2022 is going to be an excellent year for tools.
We expect a great version three of DAX
Studio next year. At SQLBI
we contribute technically and financially as a gold sponsor.
Our goal at SQLBI is to improve
your productivity and we are happy to do that
also with a free, open source tool.
And on the content side,
we prioritize a new version of Optimizing DAX
while keeping other courses updated,
and we also add new content
for professionals Tabular model authors.
You'll see something early next year. And of course, always new articles and new videos.
But there is one more thing.
In 2022 we should release
two new tools. ******* and *******.
Yes. We never mentioned these tools before, we have been working on them
for many years and they should see the light next year.
On behalf of everyone at SQLBI.
I wish you a great 2022.