In this short article I will introduce the possibility to run a sql script outside of SQL management studio using SQL server command line utility (sqlcmd for short). This...
I recently purchased a new Macbook Air with Apple Silicon M1 CPU architecture (ARM). From the first time everything was fine – super experience when unboxing, everything tuned to...
Whenever we set connector to our data in Power BI, we have an option to select connection to a certain object (e.g. a table) or there is a second...
Logical functions serve us to test conditions not only in Excel. They can be used in situation when we need to compare 2 or more values and find out...
SUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, minimum/maximum and another statistic values using SUBTOTAL function....
There is a huge number of functions for date and time in Excel. they are used to extract parts of the date or time type of cell. You may...
It is nothing hard to create report using Power BI desktop for example from Excel and then upload it to the cloud on powerbi.com. But how to update the...
It is possible to connect to many data sources using Power Query (more in this article) and SQL Server database is one of them. This article will tell you...
Did it ever happen to you that the Power BI update did not work? There might be several reasons for this problem and it is always user’s fault. We...
You have a huge table with many date entries in it. You need to find out which date is after 20th week of the year or if a certain...
FILTER functions (filtering functions) are used to get values from the table. Some functions enable additional filtering in a given table. These functions are often part of different functions...
Aggregate functions in DAX language are used to get certain summarized or grouped data view. Thanks to this, we can edit high detail data in a certain column into...
CALCULATE is an important function for a large number of calculations and for those of you who actively do DAX formulas in Power BI or PowerPivot. Understanding of how...
Function REALTED is very frequent and useful in DAX language. We can use it for example when we need to search table (A) for value from other table (B)....
What about upgrading GROUP BY clause by use of useful commands? GROUP BY is used in a clause with aggregate operations. When it is used, aggregation happens throughout all...
You probably noticed that there are many functions in DAX that are similar to Excel ones (as in article here). Contrary to Excel functions, DAX haves on strange thing....
Correct table indexing in SQL Server is a base for good database performance during querying. You need to understand how SQL Server stores data into tables/indexes if you want...
We can create two types of new values using DAX in Power BI or PowerPivot. They are calculated measures and columns. Difference between measure and column and its understanding...
DAX language (Data Analysis Expressions) servers for data management and editing prior reporting in Power BI or Powerpivot, similarly to function set in Excel. This language is able to return...
DAX language haves its standards as does any other language. This article sums up and describes how look the parameters of formulas. In other words, this article is about...