![]() ![]() Once you learn how to do this, you can quickly do interesting analyses, especially with all the additional filters that you can place on your data when you build an optimized data model in the background. Evaluates an expression in a context modified by filters. In this measure, I still want to calculate that total quantity, but I want to do it in a previous timeframe. ![]() In this post, we are going to learn about How to compare last year and current year sales data in Microsoft Power BI. ![]() As we move down the table, we can see that in July 2015, the result is now higher than the previous one. In this first example, Im going to show you this simple function called SAMEPERIODLASTYEAR. ***** Related Links ***** Time Comparison For Non Standard Date Tables In Power BICommon Time Intelligence Patterns Used In Power BIComparing Any Sale Versus The Last Sale (No Time Intelligence) Advanced DAX In Power BI. Power BI: Year to Date Comparison for Current vs. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |