Month: November 2023
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 […]
First-time mentoring – New Stars of Data
No technical blog post this time. I want to stand still for a moment to something completely different. Last week, on Friday, October 27th, 2023 the New Stars of Data conference had its 7th run. If you are not familiar with New Stars of Data, this wonderful event is a conference organized by William Durkin […]