A very normal calculation we do is to compare a value, for example, sales, against how we did last year. The easiest way to do this is by using the SAMEPERIODLASTYEAR function to create a measure that looks like this Sales LY = CALCULATE( [Sales] ,SAMEPERIODLASTYEAR(DimDate[Date]) ) As shown in the image above this works Read More
How to Calculate Weekly Average with DAX Formulas
Backgrounds A bit of context – I have a dataset with a date table and a table which is a list of ‘Tickets issued’. They are linked via Issued Date. I am trying to get the average number of tickets Issued a week, for each location (tickets have the location that they were issued to). Read More
Azure Data Studio vs SSMS
For 15 years, SSMS has held the title of the top SQL Server database tool. That’s no easy feat, especially in the software world, where things can change faster than you say “blueberry pie.” But then a contender emerged, developed and released by the same Microsoft folks in 2018. It was Azure Data Studio – Read More
ALL vs. ALLSELECTED in DAX
ALL vs. ALLSELECTED DAX functions The biggest difference between ALL and ALLSELECTED is that the ALL function ignores all filters, regardless of where they are coming from. In contrast, the ALLSELECTED function only ignores filters that are coming from the inner query. Returning Total Sales of all Selected Countries The following expression in DAX would return the Read More
How to Split a Column with Multiple Values into Rows (Excel)
I have received some sales data from John, my favourite imaginary salesperson. He’s decided to merge some of his data. I have a list of companies on each line, instead of one row for each company. I want to have one row per company so that I can link to other company data. I start Read More
How to Import Data from JSON Files and Rest APIs into Power BI
by Ben Richardson In this article, you will see how to import data from JSON files and Power BI Rest API into the Power BI environment. Power BI is a Microsoft application for data analytics and visualization. With Power BI, you can create interactive data visualizations without writing a single line of code. To create a Read More