#SSAS

You can control the drillthrough in an #excel PivotTable connected to a #powerbi dataset or an Analysis Services database #ssas. Yes, you need #tabulareditor, and yes, it is (much) faster than putting many columns in a PivotTable.

You already know that bidirectional filters are powerful but dangerous, right? Because they introduce ambiguity. In the numbers. Of your report. This 15-minute video explains why. Spoiler: use CROSSFILTER! #dax #powerbi #ssas #tabular

#SSAS Today's choice! #nowsmoking #botl #sotl @AirMunro @CigarGent_CV66 @drink_this_wine @oppy8107 @WesSmith62 @CigarChairman

GROUPBY and SUMMARIZE seem similar #dax functions, but they differ in both performance and functionalities. This article+video shows how to make the right choice depending on specific scenarios! #powerbi #ssas #tabular

Tabular models (including Power BI) require marking the Date table as a date table to get appropriate results with time intelligence calculations. @ferrarialberto explains why this setting is required in a video + article. #dax #powerbi #ssas #tabular

First batch of #TabularEditor 3 Preview Invitations going out now! Big thanks to everyone who completed the survey so far! #DAX #SSAS #AzureAS #Tabular #PowerBI

Have some light reading to do...courtesy of #SQLBI team @marcorus @FerrariAlberto 👍🏽 #PowerBI #SSAS #DAX

Third article about #dax calculation groups: Understanding the application of Calculation Items. Learn what happens under the hood intersmultiple calculation items in #ssas #tabular and #azureas - and keep asking the feature for #powerbi !!

Should you use Azure Analysis Services? For large datasets, it's a big yes! Read more in my blog post. #ssas #tabular #azure #powerbi

If I wrote a blog on how to deploy #ssas on AWS, #powerbi or #azureas as one azure devops pipeline using tabular editor and PowerShell would anyone read it?

#AzureAS & #SSAS devs, here's a present for you. We hope you like it 😀

This article+video explains how to use calculation groups to change the active relationship in a model in order to let users choose among multiple dates. #powerbi #dax #ssas #tabular

#SSAS @MyFatherCigars La Antiguedad to close out the weekend and prepare for another busy week. #NowSmoking @BoneMaCracken @joe_boca

Improve code readability by using @ as a prefix for temporary column names in #dax #powerbi #ssas #tabular

If your Excel pivot table connected to #powerbi or #ssas #tabular is slower than the same report in Power BI, or just too slow for you, probably you are hitting the problems described in this article. #mdx #dax

Calculation Groups are, in my opinion, the most important new feature in DAX and #SSAS Tabular since forever:

Complete feature matrix for #ssas in #sqlserver 2016 available. DAXMD supported in standard edition.

After months of work, the new Mastering Tabular video course is finally available. Learn how to create enterprise-grade Tabular models with Power BI and Analysis Services. #powerbi #analysisservices #ssas #tabular

New blog post (loooong overdue): DevOps with Tabular Editor part 2 #DAX #SSAS #AzureDevOps

#SSAS w/ @AFuenteCigars #Nowsmoking after washing the truck and camper, relaxing now! @The_Ozzfather @joe_boca @CigarGent_CV66 @AirMunro