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,
Tag: Power BI
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
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
Find DATEDIFF In Power Query in Hours, Minutes & Seconds.
Unlike DAX, In Power Query, the Difference between 2 dates can be calculated by simply subtracting 2 date columns. But the problem is that the resulting column is in the Duration data type. Duration data is rarely helpful in any visualization so we have to convert duration data to units like Hours Minutes & seconds
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
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
Organizational hierarchy is a common data type we get to work with when working on a data set. Hierarchies could be most commonly an organizational structure, a product item list, or a warehouse distribution route. In this post, we will discuss 5 parent/child functions of DAX and how to use them in Power BI projects.
What is PARALLELPERIOD function in Power BI? We generally use it to get a time period shifted forward in time or back from a specified time period and use it to aggregate values in DAX. There are other DAX functions in Power BI which does shift time periods. In this post, we are going to
There are different ways to show/hide an object on the Power BI canvas base on user input, conditions, values, etc. This is the first post of a series of posts that describes different methods to do that for different use cases. In this post, we are going to discuss how to show/hide an object using
Control which currency is displayed with a slicer in Power BI
When creating a Power BI report, most of the time you have to work with different currencies. In some cases, the user prefers to have user controls like a slicer to swap between 2 or more currencies in the report. In this post, we are going to discuss a few methods, from simple to advanced.