Sales Report in Power BI and Direct Query into SQL DatabaseWhenever 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 […]
AND, OR Logical Functions in ExcelLogical 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 […]
Excel | Subtotal – 11 Functions in OneSUBTOTAL is a little strange function. There are 11 mathematical functions hiding inside it. We can calculate sum, arithmetic mean, spread, […]
Excel – Function for date and time – YEAR, MONTH, DAY, HOUR, MINUTE, SECONDThere 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 […]
Power BI Gateway – Introduction Into Tool For Report Refresh/UpdateIt 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 […]
Connecting to SQL Server | Power QueryIt 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 […]
Power BI Refresh Does Not Work – Reason?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. […]
WEEKNUM, ISOWEEKNUM,WEEKDAY Excel – Was it on Friday After 15th Week of The Year?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 […]