In today’s blog, you will learn how to use Power BI to split column by delimiters using DAX. This is something you would probably know how to do easily using Power Query, and that is generally the best way to do it. But because of the dynamic nature of the problem and the specific considerations
In this tutorial, we’ll discuss SQL temp tables and views. These two can be handy if you want to pull a specific set of data from a physical table for testing and debugging. We’ll also talk about the 2 types of temporary tables and their differences. With SQL temp tables and views, you can freely
In this blog, we’ll discuss how to filter in SQL. We’ll explain and show some examples utilizing filtering conditions such as IN, NOT IN, LIKE, and NOT LIKE. These filtering conditions are used to filter the output from the data. Instead of selecting them using multiple lines of commands, it will be easier for you
In this tutorial, we’ll be discussing the different aggregate functions in SQL and how we can use them. In SQL, aggregate functions are used to accumulate data from multiple rows into a single summary row. Aggregate functions in SQL can be very helpful for analysts when doing data summarization. Commonly Used Aggregate Functions In SQL
In this tutorial, you’ll learn about the queueing capability of DAX. You’ll learn how to use it to load data from the SQL Server Analysis Services (SSAS) to Power BI. In this example, a SQL Server data model has already been created. It contains tables for the Customer, Dates, Products, and Sales data. You’ll learn
