eg 2020 to 2019, 2021 to 2019, 2022 to 2019? You can add a field to the Breakdown simply by drag and drop it to the breakdown section. Before we conclude, here is the final behavior of our report: As we saw, Power BI is quite a powerful tool when it comes to time intelligence calculations. , your one-stop-shop for Power BI-related projects/training/consultancy. A more static and agreed-upon number ensures consistency over time. The user selects two different time periods (current, comparison) through slicers. If you want to learn more about Power BI: read Power BI book from Rookie to Rock Star. Time intelligence calculations in DAX are usually created considering consecutive periods in any type of comparisons. Use Power Query to Compare Database Records - Excelerator BI If you get the same result in a year level context, it doesnt mean that all these functions are the same! Sales tax will be added to invoices for shipments into Alabama, Arizona, Arkansas, California, Colorado, Connecticut, DC, Florida, Georgia, Hawaii, Illinois, Indiana, Iowa, Kansas, Louisiana, Maryland, Dax-sameperiodlastyear (Compare Current Year With Previous Year Sales Using Measure to Compare Current Period to Previous Period - Power BI Comparison Previous Period vs Current Period in Tableau If you're on Snowflake, use the first section and the second for BigQuery! He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Previous vs. Current and Prior vs. Current - TIBCO Software Sales = SUM(FactResellerSales[SalesAmount]) instead of Sales = SUM(FactInternetSales[SalesAmount]), I might have used the wrong measure name but the tale name looks alright to me . Power BI Publish to Web Questions Answered. A table containing a single column of date values. 40213 Dsseldorf If you want to get the sales for last months; then ParallelPeriod is your friend. Hi PBI users, I'm looking to create a dynamic SAMEPERIODLASTYEAR calculation. You need to follow only three simple steps using DAX to achieve this in Power BI. Read more, ALLSELECTED is a powerful function that can hide several traps. Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. . it is not alphabetical, and it is not based on the Sales value either. The light blue line is showing the current period and the dark blue line is showing the previous period in the visuals. Cheers The only thing which we need to keep in mind is to normalize the value so that we can compare two different periods on the same axis. The output is in the screen shot (and also in the PBIX file), although here I have hard coded the report cycle names in the measures to illustrate what I am trying to achieve dynamically. Click Set from Field and select the date field. Our next task is to show CP Value and PP value based on start date and End Date, on top of the line chart to improve the readability of the view. Compare equivalent periods in DAX - SQLBI This gives us "8/8/2019" for the last sales date and then move it back one year to "8/8/2018". the screenshot below shows it; For example; for September 2006, SamePeriodLastYear returns September 2005.