Home ยป Archives for November 2023
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 available. I tried an alternative way: going to the Model Section in the Tabular Editor toolbar. But unfortunately, the option…
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 at any time of the year. Because of this, writing Year-To-Date calculations in DAX for your Tabular Model might seem challenging. In the step-by-step example, we are working for a company that starts its Financial Year on July…
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 and Ben Weissman. The conference’s goal is to give newcomer speakers a virtual stage to present for the very first…
