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 have needed to extract some certain parts of the data of date and time data types, for example month. All functions have identical and absolutely simple… Read More »
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 cloud data when the source file is located on your PC/server and “the cloud service does not see the data”? One of the ways is to… Read More »
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 how to set connection to SQL Server table directly from Excel in few simple steps. Guide to Data Import and Connecting to SQL Server from Excel… Read More »
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 will model a few of these situations on a timesheet. Our goal is to find out why the report refresh does not perform without an error.… Read More »
As SQL Server administrators, we might want to know what is happening on the server during the day and if any unwanted incidents are occurring. This is where Alerts come into play. If an event occurs that is monitored by a defined alert, a notification will be sent via email to the operator who can… Read More »
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 date is Friday. MS Excel will help by three functions – WEEKNUM, ISOWEEKNUM,WEEKDAY . It is definitely more effective than searching in calendar. More so if… Read More »
DAX function 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 as is nested parameter and enable dynamic calculations. They often serve as a value filter for function CALCULATE. Mostly it is the case of… Read More »
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 more simple and reportable form using aggregation. We can for example sum up (SUM, SUMX) some financial metrics by individual category or express maximal/minimal (MAX, MAXX,… Read More »
DAX function 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 the function works and how it is used does not look simple at first glance. And that is why this article is here. Syntax… Read More »
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). And finding the according value is the exact task of this function. Syntax is very simple: How Come RELATED Function Needs Only 1 Parameter? Data organization… Read More »