Now, you need to create a new variable using the VAR function. This function is the key in creating the solution for this example. Whenever you encounter problems in Power BI that require the maximum date or number, the MAXX DAX function is the best one to use. This is the logic used on the formula for the Max Date: This new column will contain the Max Date. The first step is to create a new column in the table that was given as an example in the forums. Here’s how to solve the problem using Calculated Columns. Here’s how to work out the most recent date for any dimension in your data set using two solutions. Using a Calculated Column gives more aesthetic while using a Measure allows your models to be more dynamic. You can perform the solution using calculated columns or measures. ![]() ![]() There are a couple of ways to solve this. You want to work out the most recent or the last time that a particular customer took the survey. The example presented in the forums was in the form of a survey data. ![]() So, you want to work out the recent value for that particular customer name. For this example, there’s a list of data and within that list the customer is referenced multiple times.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |