Removing data is a crucial step When cleaning data of any new data set. It’s essential in any dimension table to have unique values to be able to create one-to-many relationships on power bi. In addition to that, it’s useful to get only unique values at any stage of the data visualization process. In this
Category: DAX
If you’re stuck with a syntax error and looking for the short answer, here it is. IF function (DAX) – DAX | Microsoft Learn Let’s move on to the long answer. IF Statement in a Custom Column with one condition You can use an if statement in a custom column with one condition, multiple conditions,
Getting a running average in Excel is pretty easy. You just need to add the last 12 cells in the AVERAGE ( ) formula and autofill the table would do the trick. In Power BI, however, it’s a little bit tricky. In this post let’s find out how. The DataSet Table of sales values of
In this post, we are going to find out how to, Getting the previous 12 months (or any number of months) is a pretty common requirement in Power BI dashboards. A simple measure would do that. But what if the dataset is missing data from this month or a few months from the current month?
This is the 2nd post of the Excel-to-Power BI series and in this post, we gonna discuss how to count with condition or perform a COUNTIF( ) in Power BI. Is there a COUNTIF in Power BI No. COUNTIF is not directly available to use in Power BI. However we can do count with condition/conditions
If you are transitioning to Power BI from Excel, you may have used the SUMIF () function to calculate the sum of a range based on a condition. You may have been confused to find out that in Power BI there is no single function to get SUMIF (). Is there a SUMIF() in Power
In this blog post, Let’s discuss how to use Power BI DAX to compare the current day’s data with the previous day’s data in the current context. We’ll do it by using the stock price of 5 top US companies and then move on to, Compare the current month data with the previous month data
In this blog post, Let’s discuss how to use Power BI DAX to compare data from the last month with data from this month. We’ll start by using the selling price of 5 Products and then move on to, Compare this month’s prices with last month’s prices – using PREVIOUSMONTH () We have 5 popular
In this blog post, you will learn how to use the DATEDIFF function in DAX to calculate, Get DATEDIFF in Hours Here we have 2 columns in the DateTime data type. Order Date and Delivery Date. Let’s calculate the number of hours it took to complete the order. Create a new column. Here is the
The SUM ( ) function is one of the first functions any DAX beginner would learn that would perform a really simple summation calculation. In Power BI you meet SUMX ( ) function which looks almost the same and performs the same calculation, but with a little twist. In this post let’s find out why