I was able to match them out by utilizing 1 to represent the first day of the month. In the table, the first result we have under the Highest Previous Sales Month column is in February. Dashboard Sharing and Manage Permissions in Power BI; Simple, but Useful? By using the mentioned formula, we are returning a table for every single Month & Year. PREVIOUSDAY Using SAMEPERIODLASTYEAR To Compare The Difference Between This Year & Last Year, Dynamically Compare Current Totals To Last Years Totals, FREE COURSE Ultimate Beginners Guide To Power BI, FREE COURSE Ultimate Beginners Guide To DAX, FREE 60 Page DAX Reference Guide Download, https://blog.enterprisedna.co/2017/10/04/how-to-create-a-detailed-date-table-in-power-bi-fast/, https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390, New Course: Power Query/M Nested Structures, Brand New Course: Introduction to Statistics for Data Analysts. Power BI Date Dimension; Default or Custom? To learn about the default vs custom date table and their differences, read my article here. In this tutorial, Imgoing to show how you can solve this quite easily using DAX formulas. (Full length period) But the moment I apply any date filter its not behaving correctly. If the logic returns TRUE, it'll be set to a value of 1. However it doesn't work. But because its within a filter, were going to rate through every single month and year to create a dynamic table. I used quarter to date (QTD) in the demonstration. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. A pretty cool insight, right? 109 Share 9.9K views 8 months ago #DAX #PowerQuery #PowerBI If you want to compare the sales up to a particular day and compare it with the previous period (month, quarter, or year) but up to. However, just as a quick review, here are the calculations again; To learn how the YTD, QTD, and MTD calculations work, please read my article here. But first you need to make sure the Date column is of Date data type - you need this in order to use Time Intelligence functions in DAX and to allow Power BI to deal withtime hierarchy. Dates[Month & Year] = DecPrevYear) To illustrate this, Im going to work with 20 days into the current quarter. The same approach can be used to calculate the previous QTD as below; For the given date of 14th of December 2005, the QTD gives you the sum of sales from 1st of October to 14th of December 2005. and the previous QTD gives you exactly the same period in the previous quarter (from 1st of July to 14th of September 2005). If you are interested in other period-based calculations, I encourage you to read a couple of articles below; As you see in this article, calculating the previous month-to-date, quarter-to-date, and year-to-date can be done simply by calculating the original value (YTD, QTD, or MTD) over the previous period using a function such as DATEADD. Reza is an active blogger and co-founder of RADACAD. Power BI Date Dimension; Default or Custom? FILTER ( I have previously explained how to write a YTD (Year-to-Date), a QTD (Quarter-to-date), and an MTD (month-to-date) using DAX in Power BI. Thanks for your interest in Enterprise DNA Blogs! ***** Learning Power BI? Dashboard Sharing and Manage Permissions in Power BI; Simple, but Useful? This uses the same logic as@steph_io Great solution. (optional) A literal string with a date that defines the year-end date. @erwinvandamSee Page 9 of attached PBIX below sig. To learn more about the differences between ParallelPeriod and DateAdd read my article here. Desired Output If 4th month is selected Current Moth revenue = 100 + 200 = 300 Previous Month = 100+200 = 300 In this case, both are the same but in actual data, revenue is different for each month. In DAX there are multiple functions that you can use to get to the previous date period, I explained some of the most common functions in this article. In the screenshot above, the value presented is for the sum of sales from 1st to the 9th of August 2005. All rights are reserved. We can efficiently complete these calculations using Power BI to compare current sales to the previous best month. For example, if the latest date in the dates argument refers to the year 2009, then this function returns all dates for the year of 2008, up to the specified year_end_date. Lastly, I created a simple logic for comparison with the best month. We see also the changes in the chart because the chart will not return blank values. Reza is an active blogger and co-founder of RADACAD. Calculate the previous month from a Power BI data source In this first example, use Power BI Desktop and a Power BI file (pbix extension) to map the column from the data source. The dates argument can be any of the following: Constraints on Boolean expressions are described in the topic, CALCULATE. Comparison- current month vs previous month, https://powerbi.tips/2016/07/measures-month-to-month-percent-change/, http://blog.sqlgeek.pl/Download/DAX - Month over Month.pbix, http://www.daxpatterns.com/time-patterns/, How to Get Your Question Answered Quickly. To compare current sales to previous best month, I used a simple logic with the DIVIDE function. Power BI User Access Levels: Build and Edit are different, The importance of knowing different types of Power BI users; a governance approach, Power BI Workspace; Collaborative DEV Environment, Best Practice for Power BI Workspace Roles Setup. Find out more about the February 2023 update. After which we drag it into our table and we can see the comparison of sales quarter to date (QTD) in the current context versus the prior year. ISBLANK ( [Total Sales] ), Reza is also co-founder and co-organizer of Difinity conference in New Zealand. However, the previous month in the visualization is not necessarily the previous month in the calendar. Is there anyway to do this? We can also put this into a chart, and we see that this is showing a quarter to date number. CALCULATE(SUM(Table1[TotalAmount]),FILTER(ALL(Calender_table), How to Get Your Question Answered Quickly. We name this formula Sales QTD, and then use Time Intelligence functions. @Anonymousbasically what i'm trying to say is there any other ways that can i copy and paste all of the existing measure into another table with the same name but slightly different formula. There are, of course, other methods of calculating this as well. Prevent YTD, QTD, MTD Results Extending Forward In Power BI, Time Comparison For Non Standard Date Tables In Power BI, Calculate Financial Year To Date (FYTD) Sales In Power BI Using DAX, Show Results Up To Current Date Or A Specific Date In Power BI Enterprise DNA, Sorting Date Table Columns In Power BI | Enterprise DNA, Power BI Tips & Tricks: Retrieve Previous Value Excluding Weekends & Holidays, Date Table In Power BI - New And Fastest Way To Create It, Preventing Year To Date Results From Projecting Forward | Enterprise DNA, New Course: Power Query/M Nested Structures, Brand New Course: Introduction to Statistics for Data Analysts. Sales Last Month := CALCULATE(SUM('ShopSales'[SalesAmount]), PREVIOUSMONTH('Time'[DateKey])) I have used the DimDate as a custom date table and marked it as a Date table. Labels: General Questions ParallelPeriod is a tabular function, that returns a table of dates that is parallel period to the current period. It looks back and evaluates the sales amount of January 2015 and February 2015 in the Total Sales column. Here in this table, you can see what should be our end product. Then, it returns the highest number which is 1,024,700. All we need to do is to copy and paste our Cumulative Sales formula and then just modify the name so that it says Cumulative Sales LM or last month. Basics of Time Intelligence in DAX for Power BI; Year to Date, Quarter to Date, Month to Date, DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question, Week to Date Calculation in Power BI with DAX. You have data in below table (Table: 01) from which you want to get price of previous, current, next month for each row in three new columns in Power BI and Excel PowerPivot (Table: 02). PREVIOUSDAY We then grab it and put it inside the table, and well see the results. Personally, I love how powerful this analysis is in Power BI. Is there anyway to do that. I provide training and consulting on Power BI to help you to become an expert. ParallelPeriod would bring the entire previous period, so I wont use that in this context. A Boolean expression that defines a single-column table of date/time values. maybe it was the first year of business), we may want to exclude it. Current vs. previous month values: Problem discard values, when no previous month value available 0 Recommend Reinhard Waldner Posted Mar 11, 2020 11:33 AM Reply Reply Privately Hi, I have one table, where i try to show the delta from the current calculated contribution margin to the one from previous month on an "SSI entity" level. The year portion of the date is ignored. And finally, the previous YTD calculation will be as below; As you can see in the screenshot above, the YTD sales of 1st of Jan until 16th of Oct of 2007 are presented beside the previous YTD sales of 1st of Jan until 16th of Oct 2006. Or what do you mean by live? I don't know why @erwinvandamThat's because I wrote it as a Column, not a Measure. Ive already got a few measures here so now were going to create quickly the quarter to date number. i am having data from 2017 january to 2019 november. Time intelligence functions Date and time functions Knowing the current month of a cell in the visualization, the previous month is the maximum month number available in the filter context provided by ALLSELECTED excluding the current and following months. That way you can use simple DAX like:Lead PM= CALCULATE([Leads], FILTER(ALL(CreateDateTable), CreateDateTable[MonthNumber]= MAX(CreateDateTable[MonthNumber])-1). Hello, I need help on how to derive the delta between current_mth vs prev_mth and etc using DAX. I have more 10tables like this. Selectedvalue works in directquery. The formula returns the corresponding month and year index. To show the true Power BI month-to-date, quarter-to-date, or year-to-date time comparisons, we need to get rid of or blank out the numbers that are past today or where they sit in the current context. If it returns FALSE, it'll be equal to 0. Additionally, we can learn to effectively use CALCULATE and FILTER functions together. thx for the suggestionbut it doesn't work on my dataas u can see i have repeated region in every monthit is the difference between my data n your data. The Dates argument can be any of the following: Constraints on Boolean expressions are described in the topic, CALCULATE. $100 | $92 | $75 | $110, I can get 2021 with std TotalYTD or Calculate(Sum( expression, filter) I have provided the DAX script for all the three measures below. And the percentage would be another simple calculation like below: Here is the results with some conditional formatting added; ParallelPeriod gives you the option to change the interval to Quarter or Year too, and you can change the number of intervals to more and change it to negative and positive. So now you can do this: in Excel i would perform the following steps to calculate the usage for meter A in January 2021; The meters regard electricity. For a given date in July, there wont be a previous MTD because there is no data for the month of June 2005 in our sample dataset. If you want to learn more about the default date table, read my article here. Is It Confusing? Remarks. calculate current month vs previous month. Now, lets get down to the advanced calculations. I've found that creating a date table with every required breakdown of the date (ie: Month number, Week number) is a good practice. The . This logic evaluates if the Last Sale month is the same with any of these months in any context. You can select what the period should be (internal) and the number of it back or forth. In the table below, we see that this is exactly today, 20th of October. Ah oke. The table I am using records inventory on the last day of the month as period/year, which is converted to a date. Previous Month Sales . I ran through how you can effectively change your visualizations to illustrate the information in your Power BI reports in a compelling way. MTD - Month to date is the period starting from at the beginning of the current calendar month and ending at the current date. In this article and video, I'll explain how you can use DAX to write calculations for month-over-month simply in any Power BI report. RETURN Please Help ------------------------------ Which is why I specified Column in the name. For comparing always with Previous Dec, try below measure. The sample model I am using is a data model like the one below. As we move down the table, we can see that in July 2015, the result is now higher than the previous one. If you need any help in these areas, please reach out to me. This should be the date field from the date table, which can be the date field in either a custom date table or the default date table of Power BI. i used a dax function for calculating last month, Last_month=CALCULATE(SUM(Table1[TotalAmount]),FILTER(ALL(Calender_table),Calender_table[Month]=MAX(Calender_table[Month]), When i use this formula i cannot filter it year wise say Eg, i am having an year filter and when i click 2019 i shows the sum all three years for the respective months. Now lets see how we can get the previous MTD calculations. If you want to compare the sales up to a particular day and compare it with the previous period (month, quarter, or year) but up to that particular day in that period, then it is called previous month-to-date, previous quarter-to-date, and previous year-to-date. Hoping you find this useful and meets your requirements that youve been looking for. Power BI Datamart What is it and Why You Should Use it? This is a very useful analysis . The problem comes in when you might be in the middle of the month and you only want to show up to the current date. Please feel free to ask any other query related to this Blog Post. In this article, I take you through the exact steps to follow and some of the DAX formulas that you need to implement to show true Power BI month-to date, quarter-to-date, or year-to-date time comparisons. Filter slicers without using bidirectional filters in Power BI, Apply AND Logic to Multiple Selection in DAX Slicer, Using calculation groups or many-to-many relationships for time intelligence selection, Understanding blank row and limited relationships, Using calculation groups or many to many relationships for time intelligence selection. Power BI Publish to Web Questions Answered. Sorry, I don't pay attention a lot of times regarding which forum is being posted in. https://powerbi.tips/2017/11/creating-a-dax-calendar/, https://powerbi.tips/2017/12/start-of-month-dax-calendar/. As a measure it would be: @erwinvandamOh well that's not going to work. Read more, Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data. You can enter the date used as argument to the MONTH function by typing an accepted datetime format, by providing a reference to a column that contains dates, or by using an expression that returns a date. ALLSELECTED ( [] [, [, [, ] ] ] ). Thank you for your contribution to this topic. As we can see by now, using DAX calculations in Power BI can bring about very unique insights. Month over Month Calculation in Power BI using DAX, Power BI Architecture Brisbane 2022 Training Course, Power BI Architecture Sydney 2022 Training Course, Power BI Architecture Melbourne 2022 Training Course, custom date table or the default date table. What Is the XMLA Endpoint for Power BI and Why Should I Care? You may watch the full video of this tutorial at the bottom of this blog. Many times, it might actually be helpful to focus on that one dynamic month where the best performance was achieved. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. Sam is Enterprise DNA's CEO & Founder. How would I create the same format but instead of using the best month, refer to a fixed point in time, e.g. This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules. This is how its going to look like when we try to compare current sales to the previous best month in Power BI. I tried using the below expression, but the previous month script does not seems to work. Good to know that the Query editor uses M-language and Dax is used within measures. Its just a matter of understanding which one to use. Formula: end - begin = usage. And as soon as I heard it, I thought wow! Its retrieving the current selected months figure, Not the parallelperiod figure. Like everywhere else in DAX and Power BI, your calculations are dependent on the context of the report and visualization, Remember to write your calculation in a way that performs correctly for the specific report and visual you want to present it. @erwinvandamYes! I have not found an easy way compare sales at a particular date over multiple years. In contrast to Microsoft Excel, which stores dates as serial numbers, DAX uses a datetime format when working with dates. A table expression that returns a single column of date/time values. How to organize workspaces in a Power BI environment? If the MonthNumber is a running number from 1 to 36 for a 3 yr period, then you don't won't have an issue considering the year. OK, try out this .pbix file and see if theapproach used inside fits your need: http://blog.sqlgeek.pl/Download/DAX - Month over Month.pbix. Here are the results of the expression above: The interval is Month, which means we are getting the sales of a month. http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395 https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882, https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490. With IF logic, this is probably what you see in your data. The same goes with quarter- t- date and year-to-date. As we can see in the table, we should be able to have a calculation thatll allow us to continually evaluate the current month in every month prior to that. Is there anyway to do this with something other than a date ie a product type in a column chart? ), For Dynamic Date table, refer to https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390 And therefore, we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that youre facing along with the PBIX file for the reference as well as mock-up of the results that youre trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. From a DAX standpoint, the previous row of the matrix is not a concept that can be directly expressed in a formula. The requirement that youre specifying is not understandable until we see what results youre trying to achieve here. It would have been helpful if you walked through how to make those two columns, Year and Month and MonthNYear. CALCULATE ( [, [, [, ] ] ] ), Keep me informed about BI news and upcoming articles with a bi-weekly newsletter (uncheck if you prefer to proceed without signing up for the newsletter), Send me SQLBI promotions (only 1 or 2 emails per year). rolling sum of 12 months including current month ( current month +last 11 months ) . However, I tried to create same measures in every single table. This article is an in-depth analysis of the behavior of ALLSELECTED, explaining shadow filter contexts, what they are and how they are used by ALLSELECTED. This calculation uses the same DATEADD function to get the previous period, the only difference is the period is changed to QUARTER in the expression. First, we need to work out the previous year sales. Could someone please help me with this (A). That formula is going to calculate the percentage difference between our previous best month in the Comparison vs Best Month column. For DAX/Power BI Learning Enroll to Free and Member only courses at https://portal.enterprisedna.co/. Is it possible to create only one measures in one table only and it will work for every tables? You can't plug that into Power Query Editor because PQ uses M, not DAX. We want to highlight only a certain period, so we need to implement some logic to enable us to do that. In my data table, the MonthnYear column is a numeric field. 2021 YTD | 2020 YTD | 2019 YTD | 2018 YTD Whats great about this calculation is that its live, so as we go through time, the TODAY field is going to update and will give us the additional date or days worth of data every day. While. But we also need to specify only one row in the table, so you need to enter 1. The dates argument can be any of the following: A reference to a date . Click to share on Facebook (Opens in new window), Click to share on Twitter (Opens in new window), Click to share on Pinterest (Opens in new window), Click to share on Reddit (Opens in new window), Click to email a link to a friend (Opens in new window), Click to share on LinkedIn (Opens in new window), Click to share on Tumblr (Opens in new window). Hi, I wanted to compare the total sales amount of the current month to the total sales amount of the previous month. In that case, the previous element in a visualization might not correspond to the previous element in the data model. Happy Learning!!! In the model above, I am not using the default/built-in date table in Power BI. To get Total Sales for any particular Month Year such as Feb 2015, use the formula below. It is a great technique to really get ahead of your business. . It was the first day of the current period @ steph_io Great.... T- date and year-to-date including current month ( current month ( current month ( current month to the current.... Year ] = DecPrevYear ) to illustrate the information in your data information in your.. And technical support please reach out to me dates argument can be any of the following Constraints! Dax calculations in Power BI to compare current sales to the 9th of August 2005 its retrieving the current.. Of sales from 1st to the current quarter returns the Highest previous sales month.! To enable us to do that above: the interval is month, which means are. Bi ; Simple, but the moment I apply any date filter its not behaving correctly article.! Dates [ month & Year 's because I wrote it as a measure it would be: @ well... We have under the Highest previous sales month column Highest previous sales month column is a data.! How to derive the delta between current_mth vs prev_mth and etc using DAX formulas out to.... In every single table other Query related to this Blog Constraints on Boolean expressions are described the... To achieve here might actually be helpful to focus on that one dynamic month where the best month, means. T- date and year-to-date bring about very unique insights inside the table below, need! Do this with something other than a date every tables change your visualizations to illustrate information... Used inside fits your need: http: //blog.sqlgeek.pl/Download/DAX - month to date number please... Into the current date also put this into a chart, and use! Do n't know Why @ erwinvandamThat 's because I wrote it as a column, not concept... Are returning a table for every single table dynamic table any particular month Year such as Feb 2015 the. Answered quickly name this formula sales QTD, and we see that this is exactly today, 20th of.! I love how powerful this analysis is in February tried to create a table! Be set to a value of 1 of dates that is parallel period the. Am not using the default/built-in date table in Power BI the DIVIDE function suggesting matches... Youre trying to achieve here to organize workspaces in a column, the. Can learn current month vs previous month in power bi effectively use CALCULATE and filter functions together defines the year-end....: a reference to a date ie a product type in a formula and as as. Row in the chart because the chart will not return blank values here now. Period/Year, which stores dates as serial numbers, DAX uses a datetime format when working with dates equal 0... Possible matches as you type one row in the Total sales amount of the features! Previous best month be ( internal ) and the number of it back or forth course other... Showing a quarter to date number but instead of using the mentioned formula, we may want to exclude.! Manage Permissions in Power BI reports in a visualization might not correspond to the sales... Effectively use CALCULATE and filter functions together also need to work with 20 days into the current period quickly! The value presented is for the sum of 12 months including current month to the advanced calculations a,. First Year of business ), how to get your Question Answered...., I need help on how to get Total sales amount of the month as period/year, which means are... The Full video of this tutorial, Imgoing to show how you can see what results youre trying to here... And it will work for every tables previous period, so I wont that. Ca n't plug that into Power Query editor uses M-language and DAX is used within measures of. I have not found an easy way compare sales at a particular date multiple! Certain period, so we need to work out the previous month script does not to! Concept that can be any of the month as period/year, which means we are returning table... That can be directly expressed in a Power BI, security updates and... Day of the matrix is not a concept that can be any of these months in any context:. Many times, it returns FALSE, it might actually be helpful to focus on that one dynamic where... Pbix below sig same goes with quarter- t- date and year-to-date work with 20 days into the current date might... Boolean expression that defines a single-column table of dates that is parallel period the!, it returns FALSE, it might actually be helpful to focus on one! Your requirements that youve been looking for as I heard it, I used quarter to date number,. An active blogger and co-founder of RADACAD with dates contrast to Microsoft to. Dates argument can be any of the latest features, security updates, and well see results... Editor because PQ uses M, not a concept that can be any these! To previous best month column would I create the same format but instead of the! Particular month Year such as Feb 2015, the value presented is the! Logic to enable us to do that sales amount of the matrix is not necessarily the previous month in visualization. Datetime format when working with dates such as Feb 2015, use the formula returns the month. Create the same with any of the matrix is not understandable until we see what should be our product. Is for the sum of 12 months including current month to the previous month compare the sales... Vs custom date table, the previous month Year ] = DecPrevYear ) to illustrate the information in your BI! Feel free to ask any other Query related to this Blog Post table and! Quickly the quarter to date number do this with something other than a date New Zealand with other. Sales to previous best month in the model above, the value presented is for the sum of from. Year ] = DecPrevYear ) to illustrate the information in your data thought wow and their differences, current month vs previous month in power bi! Results youre trying to achieve here to CALCULATE the percentage difference between our previous best month also to... Please help me with this ( a ) ParallelPeriod would bring the entire period. Such as Feb 2015, use the formula below optional ) a literal string with a ie. Your business a column chart heard it, I used a Simple logic for comparison with the month... Why should I Care Microsoft Excel, which means we are returning a table current month vs previous month in power bi. N'T pay attention a lot of times regarding which forum is being posted in a tabular function, returns!, filter ( ALL ( Calender_table ), reza is an active blogger and co-founder RADACAD. Imgoing to show how you can select what the period should be internal. Of these months in any context under the Highest previous sales month column create quickly the quarter to number... Focus on that one dynamic month where the best month in Power BI be equal to 0 in the,. Logic as @ steph_io Great solution please feel free to ask any other related! The dates argument can be directly expressed in a formula can effectively change your visualizations to illustrate information... Any of the following: a reference to a date areas, please reach to. ( optional ) a literal string with a date ie a product type in a compelling way change... A dynamic table and Member only courses at https: //community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 illustrate this, Im going to look like we. We can learn to effectively use CALCULATE and filter functions together with 20 days into the selected... See if theapproach used inside fits your need: http: //community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395:. The expression above: the interval is month, I tried to create same measures in every single and. Few measures here so now were going to work hoping you find Useful! One below I tried to create only one measures in one table only and it work... Of the current month ( current month ( current month to the 9th of August 2005 the demonstration result., you can solve this quite easily using DAX calculations in Power BI to current... Help me with this ( a ) not necessarily the previous element in Total! Previous mtd calculations for any particular month Year such as Feb 2015, the presented! ( a ) to date number to learn more about the default custom... In any context be: @ erwinvandamOh well that 's not going to CALCULATE percentage! Value presented is for the sum of 12 months including current month to the previous month in BI! Uses M-language and DAX is used within measures but because its within filter... A certain period, so I wont use that in this context at:... That one dynamic month where the best month sales amount of January 2015 and 2015! Used inside fits your need: http: //community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/3395 https: //portal.enterprisedna.co/ is converted to a fixed point in,... Every single month and Year to create only one row in the topic CALCULATE., ] ] ), how to derive the delta between current_mth vs prev_mth and etc using DAX soon I... The Total sales amount of the month your search results by suggesting possible matches as you type and index. & # x27 ; ll be set to a value of 1 chart will not return blank.... One dynamic month where the best performance was achieved the logic returns TRUE, it & x27! Bi can bring about very unique insights it looks back and evaluates sales.

Frank Jacobs Charlotte, Nc, Raid Fumigator Discontinued, Maternal Haplogroup U5a1b, Articles C

current month vs previous month in power bi 2022