Year over yaer of grandtotal1/5/2024 ![]() Power BI offers several DAX time intelligence functions. You won’t break anything.In Power BI, we may want to compare periods with our data to create reports such as year over year comparisons. Now that I’ve shared its pros and cons, I encourage you to try the Quick Measures feature yourself and weigh in. Having a high level of understanding of its core functions will allow you to implement calculations properly. It is still essential for you to get the hang of DAX to create quality reports on Power BI. But you have to be mindful when using this feature because it has its limitations. You only need to select the measures you want to create and this feature will work on it for you. Using Quick Measures in Power BI is as easy as clicking and dragging. You can start with simple formulas and branch out to perform more advanced calculations. Lastly, I want to point out that an in-depth knowledge of DAX formulas will enable you to write formulas quicker than you can click and drag fields in the Quick Measures feature. This scenario can happen very easily with Quick Measures. In doing so, you may not be able to tell when something is wrong with your data because you’ve failed to gain an understanding of what’s going on. I don’t think it’s good to simply come up with calculated results automatically. This, I think, is a better way to use Power BI.Īnother reason why I’m hesitant to recommend Quick Measures is that I believe it’s important to know what a formula is doing. The DAX formula pattern can be modified to compute Cumulative Sales Last Year. You can see that with formula patterns, you can copy and paste formulas and then change a single element to come up with a new calculation. I can do this by simply changing a single letter in the formula highlighted below, from DATESMTD to DATESYTD. You can’t do this with Quick Measures in Power BI. What’s more, I can use a technique that will enable me to calculate Sales Year-To-Date from Month-To-Date without the help of Quick Measures. The formula is much more concise and easy to follow. It’s comprehensive but it makes things more complicated than it’s supposed to be.Ĭonsider this Sales Month-to-Date measure I created without using Quick Measures: What this formula tries to do is cover every possible scenario where the Quick Measure might be used. You also don’t need the dotted date highlighted below. What’s more, Quick Measures uses TOTALYTD whereas I prefer to use DATESYTD inside of CALCULATE. There is no need for an IF statement, an ERROR statement, and an ISFILTERED statement. Take a look at our Total Sales Year-to-Date calculation.įirst of all, the information below is way more complicated than it needs to be. I can come up with those measures by using table functions and by having a thorough understanding of how DAX core functions work in Power BI.įor example, in using Quick Measures for simple Filters, you can use the FILTER function instead as I’ve discussed in previous tutorials. You can utilize it to do Totals, Time Intelligence, Filters, Aggregates Per Category, Text, Mathematical Operations, and Concatenated Lists among others.īut the thing is, you can achieve the same results using DAX functions. One of the advantages of using Quick Measures is that it is easy to use, you just have to click and drag fields as I’ve demonstrated earlier. The Pros And Cons Of Quick Measures In Power BI This is how straightforward the Quick Measures feature is. You’ll notice here that the Total Sales was stored in the Customers’ Table because I clicked on that particular Home Table.įrom here, I can easily change where the Total Sales measure will be stored by clicking on the Home Table drop-down menu and choosing Key Measures. I’m also going to drag the Date column to the Date field.Īfter filling out the necessary fields on the Quick Measures dialogue box, I’m going to click “OK.” ![]() In this case, I’m going to plug-in Total Sales by dragging the measure for Total Sales to the Base Value field. Next, I need to select a field as my base value or the measure I want calculated. Using Quick Measures, I just need to click on the Year-To-Date Total under Time Intelligence from the Calculation drop-down menu. In this tutorial, I’m going with a Year-To-Date Total calculation. Then, I’m going to decide what I want to create. To get started, I’m going to click the feature on the task pane. Through point and click, Quick Measures enables you to create different Key Measures such as the ones I’ve created below. Download Free Resources Here Using The Quick Measures Feature
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |