No Picture
SSAS Tabular Errors

SSAS Tabular Model error opening

When opening an SSAS Tabular Model Visual Studio SSDT (SQL Server Data Tools), if for example you loose your network connectivity to the repository for a few seconds, then the SSAS Tabular Model don’t open. Error: Can’t open the SSAS Tabular Model from Visual Studio SSDT. Tabular Model Designer error:

DAX functions

Calculate Last Year Value in DAX for Power BI

How to calculate the last year value with DAX in Power BI? Simply use the available DAX CALCULATE function combined with the PREVIOUSYEAR function. In financial Dashboard and Reports, use the previous year value for comparison and variance calculation with the current year. Indeed analysing financial figures is often about comparison. How to calculate the last year value with DAX in Power BI using a formula? The first option is to

No Picture
MS BI Abbreviations

DAX – Data Analysis Expression

DAX stands for Data Analysis Expression, it’s the Microsoft language to manipulates data in Microsoft SSAS Tabular cubes as well as in Power BI, and also in Excel PowerPivot. DAX: Data Analysis Expression The DAX library is a Powerful and user-friendly Microsoft library of different type of functions addressing different

SQL Server Errors

SQL Server Database does not exist sp_MSforeachdb

With SQL Server, when using the sp_MSforeachdb system stored procedure, the system displays this error “Database does not exist. Make sure that the name is entered correctly.” . The stored procedure displays the error because the database tries to access a database that does not exist in your SQL Server

SQL Server

SQL Server Alter Function

How to update the code of an SQL Server function without deleting it? The solution is to update its definition using the SQL Server Alter Function command. The query updates the function already created in the database. This new code returns not only the customer name, but also the customer