Tag: Tabular
Help – I want Tabular Model Documentation
A few months ago, I chatted with colleagues about our Tabular Model. More specifically the lack of Tabular Model documentation. Since we were thinking about replacing our current model, I started to think about how to integrate documentation easily. Having documentation is 1 thing, making sure it’s used is something completely different. And then we’re […]
Tabular Model – Help – Can’t create a DAX Calculation Group
Recipe Overview Preparation Time: 5 minutes Ingredients Problem Statement While I was writing another data recipe, I ran into an issue. For some reason, the “Create Calculation Group” was not visible / enabled in Tabular Editor. I tried to create a Calculation Group by right-clicking on the Table Folder –> Create but the option wasn’t […]
Tabular Model – DAX Time Intelligence functions with an alternative Financial Year-ending
Recipe Overview Preparation time: 10 minutes Ingredients Problem Statement Many companies don’t follow the regular Calendar as we know (January 1st – December 31st). They follow their own Financial Calendar (often called Fiscal Calendar) which can start any time of the year. Because of this, writing DAX Year-To-Date calculations for your Tabular Model might seem […]
Azure DevOps Pipelines – Release your Tabular Model without Users & Roles
Problem statement A couple of weeks ago my team & I ran into an issue with SQL Server Analysis Services (SSAS), due to a network split between companies, We weren’t able anymore to manage our SSAS access into our SSAS Tabular Model. Since deploying a Tabular Model using Visual Studio is also overwriting members & […]