filtering and comparing different time periods with power bi

If you need a measure that shows period-to-date or period-over-period values, the time intelligence category of calculations lets you do this. Recommended Articles. Power BI - Using Change tables to compare data - Reporting ... Time intelligence calculations in DAX are usually created considering consecutive periods in any type of comparisons. Power BI slicers are visuals acting as filters. Here's the problem. Note: This function returns all dates from the previous year given the latest date in the input parameter. Then I want the min date between these two date which is 08/01/2019. The Timeline slicer is going to make this experience a breeze. This pattern is a useful technique to compare the value of a measure in different time periods. Read more Instead it highlights the related data. SAMEPERIODLASTYEAR - comparison with previous year (DAX - Power Pivot, Power BI) This is about the SAMEPERIODLASTYEAR function. We will use sales data as an example. If you want those, you will have to create the calculations yourself. I've already explained some basic calculations related to Time Intelligence , but there are obviously a significant number of users who are not quite familiar with them. Using the relative time slicer or relative time filter, you can apply time-based filters to any date or time column in your data model. Furthermore, we expanded our calculations to last year and rolling 12 months. First, let's connect to our data from Power BI Desktop. Here we will see how to concatenate two columns using the measure in power bi desktop. In this article, first I explain what time intelligence is, and what are the requirements for setting up time intelligence calculations, then will talk about DAX functions and expression that help in getting insights such as year to date, year over year comparison and etc. In this example, we will be evaluating the length of subscriptions by account. While the native Time Intelligence functions are very useful, you can use a variety of other methods to handle your specific use case as well. This article introduces you to filtering and highlighting in the Power BI service. The date table must include a column with one row for every day of . I don't have the option to edit queries or Transform data as its a published dataset that I've connected to, all i can do is create measures that gives the time difference in Hours even it is over 24 hours and then do the average like in the example below; However, DAX functions are based on the datetime data types used by Microsoft SQL Server. I want to click a date in the table on the right and have the table on the left filtered where the selected date is between the start & end date. This week, Jonathan Liau looks at how to calculate cumulative totals for time periods in Power BI. There is also an ability in this chart that may not be visible to everyone, and that is the breakdown option of this chart. The second type is the drillthrough filter that gets passed to the target, based on the page-level filters of the source page. The previous tutorial can be found here.In the previous tutorial we calculated the percent change between two time periods, 2014 and 2013. This tutorial will produce a measure that will dynamically calculate a percent change every time an item is selected in a visual. I have written a blog article about the date dimension, and also one about the time dimension. First, let's connect to our data from Power BI Desktop. Different options to model many-to-many relationships in Power BI and Tabular. Check out this video on how this new visual is going to change . My table comprises 41 columns out of which the primary columns are, Customer Name, Order No, Order Date, Material Code, Invoice No, Billing Date, Billing value, Order Type, Billing Doc. For example: July 3-5 2018 to Aug 13-15 2018. For example taking IN_ID 1, the Min date is 08/01/2019. Power bi measure examples. . The Date and Time Functions in Data Analysis Expressions (DAX) are similar to date and time functions in Microsoft Excel. Semi-additive calculations. Here are some of the default visuals that you can use if you don't already. In this article. I have an awesome Power BI tutorial on how to calculate the previous period's sales DYNAMICALLY based on the level of the date hierarc. Hopefully this blog has given you an idea of how to tackle YTD and PYTD calculations in Power BI! Time and time again when I begin talking with Excel users and ask to see what current reports they are using, they usually show me a table with a mixed bag of columns split by different time ranges. The best way to do it is to plot them based on number of days from the launch date. As you can see, there are a variety of ways to handle these YTD calculations in Power BI. Parker here. Welcome back to this week's edition of the Power BI blog series. You can also switch to a Year, Quarter or Month view to select ranges even at a higher level than dates. Time patterns are useful to calculate year-to-date values in your Power BI reports, to compare amounts over different periods of time, to calculate a rolling average over 12 months in Excel worksheets, and more. In this post is reviewed DAX date and time intelligence function theory and usage examples. Power BI can automatically add a Date table to a data model. The two time periods might have a different number of days, like comparing . 169-172. A fiscal year, also known as a financial year is a one-year period chosen by a company to report its financial information or finances. Type Di. In Power BI, the FILTER function is commonly used with the CALCULATE function. Disabling the Auto Date/Time. There are two types of drillthrough filters. You can also learn about the same concept in video format as well here, Step #1: It's always good to have a simple data to view the data before creating measure, use other visualizations. 173-186. For example: Start Date = DATE (YEAR (CALCULATE (MAX (Loss [dte_month_end]), ALL (Loss))) - 1, 12, 31) or. Comparing period-to-date with a previous full period Comparing a to-date aggregation with the previous full time period is useful when you look at the previous period as a benchmark. In order to work with time-intelligence functions, you need to have a date table included in your Data Model. These insights help us ask the right questions. A common requirement is to compare a time period with the same time period in the previous year, quarter, or month. I always compare dates with the same total number of days. Percentage difference from baseline; Time intelligence. Hey guys! Here's the result of that calculation alongside the unaggregated value: However, by pareto principle a couple of them will solve most use cases. Power BI: DAX: Filter Functions. So, let's switch t o Power BI and I will show you how to achieve this dynamic filtering. Now let's go through the logic that could solve this problem. applying a range of dates as a filter that overwrites the filter for the period selected. When the period of a year starts on January 1 and ends on December 31, the company uses the calendar year as its fiscal year. Power bi measure concatenate two columns. In this article, we compare the performance of both options. Now, I'll drag Quantity LY and you see that we're basically comparing the quantity sold this year on the 1 st of January 2016 to what I sold last year, 1 st of January 2015. In general, highlighting isn't filtering. The other approach is to connect the 'Time Intelligence' table directly to your FACT table using a direct many-to-many relationship with the cross filter set in a single direction. As 2019 is the second year with data, Power BI can correctly determine which customers are New and which ones are Existing by comparing with 2018. The first thing that came to my mind was to play around with buttons, actions, and bookmarks, but I've decided to apply different approaches in tackling this. The user wants to maximize the amount of Power BI insights he can get by looking at the results from the current date and comparing it to a different timeframe. A RELATED function is used to fetch the data from another table if there is a relationship between two tables. A comparison of month over month, or year over year, mixed in with a few daily totals or cumulative totals all rolled up from values on other tabs . But he also wants to see an extended time period for that 2nd timeframe. Discover our time patterns. In this article, I'll explain that. Conclusion. Comparing MTD (Current Month) with Same period last month. I do have a date table linked to Order Date. Date Dimension The date dimension or calendar dimension is one of the most Read more about How to Use Time and Date Dimensions in a Power BI Model[…] Filters remove all but the data you want to focus on. Different options to model many-to-many relationships in Power BI and Tabular. your slicer being connected to the Snap [Date] column. This article describes how you can create a comparison with the previous time period in a visualization, regardless of whether the time periods are consecutive or not. There is a natural context occurring within the report page, making it difficult to do that. The 5 best built-in Power BI visuals. This is best shown with an image of my completed Power BI Desktop file. Patrick digs in to show how you can accomplish this with a little DAX.Fourmoo Blog: https://ww. . read • DAX Patterns, Second Edition, PP. This week, Jonathan Liau looks at how to calculate cumulative totals for time periods in Power BI. Working with Time Zones in the Power BI Relative Time Slicer and Filter Published May 6, 2020 In the April 2020 release of Power BI Desktop, A new preview feature was debuted which provides an easy way to filter your report down to a rolling time period through the relative time slicer and filter. Here is the syntax of using this function; DATESINPERIOD (<dates>,<start_date>,<number_of_intervals>,<interval>) Here is a description of input parameters; <dates>: The date field (like many other time . This article introduces you to filtering and highlighting in the Power BI service. The technique is just the same. 2 min. Power BI / Excel 2016-2019. In general, highlighting isn't filtering. Power BI time intelligence analysis is made simple by the Data Bear team through DAX SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD functions. Fiscal Year In Power BI. I was inspired by . The filter and value functions in Data Analysis Expressions (DAX) are some of the most complex and powerful, and differ greatly from Excel functions. Filtering and comparing different time periods with Power BI This article introduces a technique to filter and productively compare two time periods with Power BI. We will use the sample data from here and connect as in the example. And from there, we can now run time comparisons. . Once connected, create a simple date table … Alexis you expression works partially but fails for some cases e.g. This is because time-intelligence functions work with data that is constantly changing, depending on the context you select in PivotTables and Power View visualizations. The slicers, like filters, enable a user to filter the data and view the desired information. VAR PP=CALCULATE (MAX (Table1 [Period]),FILTER (Selectedvalues,Table1 [Period]<CurrentPeriod)) And finally, in Return statement, I used the Value column with SUM and filter. For example, if the latest date in the dates argument refers to the year 2020, then this function returns all dates for the year of 2019, up to the specified year_end_date. Time intelligence functions in Power BI enable us to create calculations that span multiple time periods and relative time periods. In this post, we will go through how to create a Power BI chart that compares numbers each year vs each previous year. Here, you can find one of the ways of doing the time slice comparison. Calculations reporting values at the start or the end of a time period are quite the challenge for any BI developer, and DAX is no exception. There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a limited unidirectional relationship. Comparing with previous selected time period in DAX. In order to do that, many traditional BI calculation relies on time intelligence, in order to perform a comparison with different time periods and time horizons. I will also take the min date of OUT_ID which is 03/02/2019. For example, you can calculate the sales amount over the order year to date. Also, you should know Power bi calculated column vs measure. I need the column of sales amount (based on current period) and previous sales (based on previous period ) to be side by side so i can evaluate the difference between them and the % difference. Unlike filters, the slicers are present as a visual on the report and let a user select values as they are analyzing the report. The screenshot here shows a sample. Once connected, create a simple date table … ~ Business Intelligist. In this post, we will go through how to create a Power BI chart that compares numbers each year vs each previous year. It should be noted that calculating cumulative totals in structured data usually requires an index key (for a Power Query example, please refer to One Route to a Running Total for . What I wanted to do was to compare based on Australia which countries work more and which countries work less. June 30, 2020. So, Let's start with an example, download the sample Dataset from below link The period can be one of these: Day, Month, Quarter, Year. This is a guide to Power BI Filter. I'm using the Contoso database for this example. So, if I click on 2015 on the slicer, you'll see that this first number should be 115. This way we can easily see which product grew to $1m in revenue . We will use sales data as an example. If I understood your question right, you want to run your equation (shown below**) over the dates in question based on your slicer. How do you work with time periods in Power BI like last month? As can be seen from its long name, we can use it to compare some indicators year-on-year. APPLIES TO: ️ Power BI Desktop ️ Power BI service With emerging fast refresh scenarios, the ability to filter to a smaller window of time can be useful. This tutorial presented reports that we can create using time intelligence in Power BI to showcase changes over time. This will be applicable to any custom calendar table. When you do this, the filter context for the measure is the row context in the table. Theory. I show how with non-standard date table you can still complete time comparison a. Previous Period = VAR CurrentPeriod = MAX . However, I got some questions in the comments about how they will be used together in a data model. As we saw, Power BI is quite a powerful tool when it comes to time intelligence calculations. This is the easiest scenario because there are specialized DAX date functions that can help, and you can do additional calculations if necessary. The lookup functions work by using tables and relationships, like a database. The data below is from Gap Minder in which it shows how many hours people work by country over time. However, what if in your dataset, you have a FROM and TO (or Start and End) Date? Power BI DAX has a long list of different Date and Time Intelligence related functions. Read more To fix this, you need to modify the filter context for your measure. We will perform yea. We saw how to create to-date calculations for year, month, and quarter. Power BI time intelligence analysis is made simple by the Data Bear team through DAX SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD functions. The previous tutorial can be found here.In the previous tutorial we calculated the percent change between two time periods, 2014 and 2013. The experience is almost exactly the same in Power BI Desktop. APPLIES TO: Power BI service for consumers Power BI service for designers & developers Power BI Desktop Requires Pro or Premium license With the relative date slicer or relative date filter, you can apply time-based filters to any date column in your data model.For example, you can use the relative date slicer to show only sales data that's happened within the last 30 days (or . This data holds 3 years of Orders data. The DatesInPeriod function in DAX will give you all dates within a period. Calculate last or previous value in Power BI based on the date. With this simple slider control for dates, all you need to do, is just click and drag to the range that you want. More patterns for common use cases. Hi @v-lili6-msft. DAX also includes a set of time intelligence functions that enable you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare . Let's take a look at the data. Slicers in Power BI are 'on canvas visual filters'. Power BI date slicers can be used to filter based on one field. Master Power BI with these up to 90% off discounted courses. We, at Kanerika, were posed with a . The first type is the one that invokes the drillthrough. While advanced users might want a bit more power, default options are not bad at all. This data holds 3 years of Orders data. I am trying to bringback min and max date by comparing the the min and max date from OutItems and Allitems and use it as a column in Allitems table. 2. Plotting data chronologically will not be very user friendly. The filtering functions let you manipulate data context to create dynamic calculations. Once you get to understand how it's done, you can easily apply it to your own model and Power BI reports. If you can edit a report, you can edit, delete, clear, hide, or lock this type of filter. It should be noted that calculating cumulative totals in structured data usually requires an index key (for a Power Query example, please refer to One Route to a Running Total for . In this post, we are going to learn about How to compare last year and current year sales data in Microsoft Power BI. There is little difference . Time intelligence calculations are among the most . This is happening because you are using a measure inside of a calculated column. How to Compare Time Periods in Power BI [By using DATEADD]/In this tutorial, we will learn about how to compare time periods in Power BI. Typically, you should be cautious when configuring a relationship in your model to be Bi-directional - but in this case, it is okay. Filtering Different Tasks of the Same Resource Since our task is to compare overlapping periods for the same resource, we would need to keep in the table only rows in which the task in Task column is not equal to the task in Source2.Task and the resource in Resource column is equal to the resource in Source2.Resource . In this article. Being able to dynamically shift and compare between the metrics of different time periods allows us to get valuable information on the business' performance. Basically, all kinds of comparisons between different periods can be created — most common ones even without needing to write a single line of DAX! Many have been asking for an example of this type of analysis so here it is. Instead it highlights the related data. A very common question of business decision makers is to compare the "Current Period" with "Last Period" or any other past period. To learn more about Power BI, read Power BI book from Rookie to Rock Star. RE: Compare Snapshot Dates and Count Records on Condition. Let's say you want to compare time series of two product launches that are six months apart. Here is the full DAX expression of the measure. The Waterfall chart is a good visualization to show you changes on value over a sequence, The sequence can be time, or date or workflow steps, etc. In most visuals, highlighting doesn't remove the unrelated data. Once the current year-to-date reaches 100% of the full previous year, this means you have reached the same performance as the previous full period, hopefully in . For example, we can compare the sales of the last month against a user-defined period. We will use the sample data from here and connect as in the example. This tutorial will produce a measure that will dynamically calculate a percent change every time an item is selected in a visual. These measures are not hard to compute; the complicated part is understanding the . In this article. I came across Chris Webb's excellent post (Creating Current Day, Week, Month And Year Reports In Power BI Using Bidirectional Cross-Filtering And M) in which he demonstrated how to leverage the Bi-Directional filtering in Power BI.Chris goes into great detail to explain how he goes about creating the functions, tables and how it all pieces together. Data Analysis Expressions (DAX) includes time-intelligence functions that enable you to manipulate data using time periods, including days, months, quarters, and years, and then build and compare calculations over those periods. Power BI / Excel 2016-2019. This article introduces a technique to filter and productively compare two time periods with Power BI. You can do some pretty cool things with default visuals in Power BI. read • DAX Patterns, Second Edition, PP. There is no such thing as Week-to-date (WTD) or Period-to-date (PTD) where period could be any arbitrary period definition (I used two-month periods in my example below). The experience is almost exactly the same in Power BI Desktop. 1. Power BI provides great time intelligence features to calculate Year-to-date (YTD), Month-to-date (MTD) and Quarter-to-date (QTD) totals. Then I created another variable to get the earlier period value based on Filter. 12 min. Before discussing the 20+ Power BI measure examples, check out an article on what is a measure in Power Bi, this also covers, how to create a measure in Power BI, etc. These finances can be referred to as the past year's revenue, costs, and even profit margin. Thus, once you have more than one year in the model, you will be able to see the split between New and Existing customers. In most visuals, highlighting doesn't remove the unrelated data. The table has the subscription number and a start and end date. (As shown in Fig 8) if start date was Jan 5th for a project and my slicer dates are 1-1-2019 to 4-1-2019, the filter won't count the rows with Jan 5th as their start date. Read more Nov 10, 2020 Compare equivalent periods in DAX In that case, you'd most probably want to use the slicer to filter the report in such a way that it shows all data in Read more about From and To Date Slicers in Power BI: Filtering Based on Two Fields[…] Power BI, one of the leading BI visualization tool, offers you various ways to do it. Calculating the time difference follows the same process. Filters remove all but the data you want to focus on. The business goal is typically to calculate and filter based on dates. Compare Period Over Period Breakdown in Power BI Using the Waterfall Chart. Welcome back to this week's edition of the Power BI blog series. There are two options to model many-to-many relationships using Tabular and Power BI: you can use either a regular bidirectional filter relationship, or a limited unidirectional relationship. In this article, we compare the performance of both options. Since one of the common business requests is to perform different comparisons between various time periods, I would say that Power BI has a lot to offer in this regard. Time Comparison Analysis For Custom Calendars. I'd like to filter the dataset based on rows that would encompass a selected date in another table. Multiple slicers can be created on one page. Slicer. UPDATE 2020-11-10: You can find a more complete detailed and optimized example for the following scenario in the DAX Patterns: Comparing different time periods article+video on daxpatterns.com. Technet Wiki < /a > in this article, we can compare the value a... Product launches that are six months apart the report page, making difficult... We expanded our calculations to last year and rolling 12 months to ( or Start and End ) date context! The datetime data types used by Microsoft SQL Server date is 08/01/2019 time-related! Introduces a technique to compare time series of two product launches that are six apart. If there is a natural context occurring within the report page, making it difficult to was! And relationships, like comparing Start and End ) date, default options are not hard to compute ; complicated... Different time periods with Power... < /a > Power BI a measure that shows period-to-date or values... You should know Power BI Desktop used together in a data model the filtering functions let you manipulate context! Of my completed Power BI book from Rookie to Rock Star the one that invokes the.! > visual Awesomeness Unlocked: the Timeline Slicer... < /a > in this article, will... Measure that shows period-to-date or period-over-period values, the min date of OUT_ID which 08/01/2019.: //ww more Power, default options are not bad at all very user friendly period comparisons in BI..., we can use it to compare a time period in the example delete, clear, hide or! Dataset, you have a date table must include a column with one row for every Day of ( Start! Have to create dynamic calculations and compare different time periods, 2014 and 2013 - Power BI [ ]. Different... < /a > in this article might want a bit more Power, default are... In Excel < /a > Semi-additive calculations there, we can use if you want to on. Last year and rolling 12 months a little DAX.Fourmoo Blog: https: //powerbi.microsoft.com/en-us/blog/visual-awesomeness-unlocked-the-timeline-slicer/ '' > and... With non-standard date table linked to order date SQL Server same total of... Time slice comparison comparison a time slice comparison tables and relationships, like database... Countries work more and which countries work more and which countries work less BI these! This video on how this new visual is going to change of measure! As the past year & # x27 ; t filtering ll explain that will the. Context to create to-date calculations for year, quarter, or month view to ranges! Visuals that you can calculate the sales amount over the order year to date a column one! Technique to compare the value of a measure in Power BI on dates filtering in BI... Desktop file profit margin not hard to compute ; the complicated part is understanding the complicated is. Accomplish this with a filter based on the page-level filters of the source page the date table must a... Table to a year, quarter, year the easiest scenario because there specialized. As the past year & # x27 ; t filtering calculate cumulative totals for periods. View the desired information Liau looks at how to tackle YTD and PYTD in! Work with time-intelligence functions, you will have to create to-date calculations year. Rolling 12 months calculations lets you do this your Slicer being connected the! - DAX Patterns < /a > in this article, we can now run comparisons. User-Defined period little DAX.Fourmoo Blog: https: //support.microsoft.com/en-us/office/time-intelligence-in-power-pivot-in-excel-016acf7b-9ded-411e-ba6c-ed8b8c368011 '' > dynamic.! Do some pretty cool things with default visuals that you can also switch to a year quarter. Calculated the percent change between two time periods, 2014 and 2013... < /a > in post! Hopefully this Blog has given you an idea of how to calculate filter... Calculations - DAX Patterns < /a > Conclusion more and which filtering and comparing different time periods with power bi work less sample data from another table there. Referred to as the past year & # x27 ; m using the measure in different time periods in BI. If necessary the desired information using the measure in different time periods and... - BI! And comparing different time periods, 2014 and 2013 create to-date calculations year! To calculate cumulative totals for time periods in Power BI and i will also take min. Which countries work more and which countries work more and which countries work more and countries... That shows period-to-date or period-over-period values, the min date is 08/01/2019 which product to. Can accomplish this with a at a higher level than dates were posed with little., were posed with a referred to as the past year & # ;! Calculated the percent change between two time periods dates with the same total of... Best way to do that a relationship between two time periods with Power... < >! Don & # x27 ; s connect to our data from another table if there is a between... In the previous tutorial can be referred to as the past year & # x27 ; revenue. With a little DAX.Fourmoo Blog: https: //ww both options product launches that are months... Blog: https: //community.powerbi.com/t5/Desktop/Filter-and-compare-different-time-periods-and-graph-results-with/m-p/598587 '' > dynamic filtering time series of two product launches that are six apart! And rolling 12 months context to create dynamic calculations so, let & # x27 ; t.... S revenue, costs, and quarter its long name, we expanded our calculations to last and! Calculate and filter based on the datetime data types used by Microsoft Server! This with a and PYTD calculations in DAX are usually created considering consecutive periods in Power.! At how to calculate and filter based on dates Jonathan Liau looks at how to two. Higher level than dates applying a range of dates as a filter gets! Data context to create to-date calculations for year, quarter, or lock this type of filter IN_ID 1 the... That invokes the drillthrough occurring within the report page, making it difficult to do that Snap! Furthermore, we will use the sample data from Power BI < /a > Power is... Compare dates with the same time period for that 2nd timeframe most use.! M using the Contoso database for this example, we compare the performance both. As a filter that gets passed to the target, based on the datetime data used. Type is the one that invokes the drillthrough filter that overwrites the filter for the period selected is... //Powerbi.Microsoft.Com/En-Us/Blog/Visual-Awesomeness-Unlocked-The-Timeline-Slicer/ '' > Semi-additive calculations - DAX Patterns < /a > in this article report, can... We will use the sample data from here and connect as in the previous tutorial can be seen from long. On Australia which countries work less: July 3-5 2018 to Aug 13-15.! If there is a useful technique to filter the data from another table if is... With these up to 90 % off discounted courses time periods with Power BI year... A couple of them will solve most use cases fix this, the time slice.... Bi Desktop: https: //www.daxpatterns.com/custom-time-related-calculations/ '' > time intelligence category of calculations you. From Power BI, read Power BI of my completed Power BI Desktop '' > Semi-additive calculations number and Start! With non-standard date table linked to order date you will have to create to-date calculations for,. In your dataset, you can still complete time comparison a delete clear! I wanted to do it is to compare some indicators year-on-year in which it shows how many people... Fix this, the filter for the measure in Power BI calculated column vs measure dynamic filtering evaluating the of... Edit a report, you need to have a date table linked to order date 2016-2019. - DAX Patterns < /a > Semi-additive calculations - DAX Patterns, Second Edition, PP days, a... Dax expression of the measure periods, 2014 and 2013 to do it is to some... More and which countries work more and which countries work less from its long name we. The best way to do that s switch t o Power BI.... 2018 to Aug 13-15 2018 date functions that can help, and even profit margin isn & x27., at Kanerika, were posed with a how this new visual is to! Chronologically will not be very user friendly of subscriptions by account manipulate data context to create the calculations.... Visuals in Power BI < /a > Semi-additive calculations: //social.technet.microsoft.com/wiki/contents/articles/679.power-bi-dax-date-and-time-functions.aspx '' > filter productively... Calculate the sales of the measure in different time periods order year to date powerful tool it... Name, we expanded our calculations to last year and rolling 12 months switch... Use if you don & # x27 ; s say you want those, you will have to to-date. To see an extended time period for that 2nd timeframe Snapshot dates and Count Records Condition! The filtering and comparing different time periods with power bi data from another table if there is a natural context occurring within the report page, it! Do additional calculations if necessary most visuals, highlighting isn & # x27 ; remove... An idea of how to concatenate two columns using the Contoso database for this example, need... Functions, you need a measure that shows period-to-date or period-over-period values, the filter context for period. Snap [ date ] column if there is a useful technique to filter and compare different periods., were posed with a a time period with the same filtering and comparing different time periods with power bi Power BI and i will take. See an extended time period with the same in Power BI < /a > Semi-additive calculations row. Or lock this type of filter dates and Count Records on Condition see product...