In today’s post we are going to talk about the Analysis Services Tabular Models, specifically one of the latest news published earlier this year: The Calculated Groups. The Calculated Groups allow us to shorten the number of measurements we have in an Analysis Services model. Read More

When we work with multinational companies, one of the key parts of our model is the Conversion to different Currencies, since, payments are made from different countries with different currencies and the users who view the reports must be able to see them in the currency they choose. Read More

In my last Post, I showed you a much faster and more intuitive alternative than Visual Studio, the Tabular Editor. Surely many of you will have been testing this new application, so if you liked it and found it really useful, you can not miss this Post! This Read More

In today’s post I will show you a Business Intelligence tool that will be of great help when creating Analysis Models. Last September, I had the opportunity to attend the data event held every year in Madrid, the SQL Saturday. In one of the sessions, specifically that of becoming Read More

In today’s post, we’re going to end up with the DimDate series in Power BI. To begin, I will show you some of the visualizations that Power Bi offers by default as well as the personalized visualizations that we can find in the Marketplace. 1.Slicer These are the types of Slicer that Power Bi Read More

By Xesco Abad Posted Wednesday April 10th, 2019 In SQL Server Spanish 0 1 One of the strengths of the DAX language is that it allows us to compare data for periods of time in a very simple and fast thanks to its intelligence functions of time. With the intelligence functions of time we Read More

Creating DimDates with Power BI is the perfect ally for your company’s data analytics. All our data models have a common dimension, the dimension of date or DimDate. Thanks to the date dimension we can make comparisons of data between ranges of dates, see how the annual production Read More