Tf2 All Class Cosmetics, Red Sox Coaching Staff Salaries, Death Longmont, Colorado, Washington State Cup Soccer 2022, Articles P

Most of my reports at work are manually updated every month to reflect a rolling 13 months (Oct 2019 Oct 2020) as shown above. Carl, Hi Carl, please read my blog article about the time zone. Once you include the slicer onto the page and than if you select any particular date range the charts or tables will not show any blanks as it was showing earlier. currently not on the Microsoft roadmap for a fix as it is working as designed.. Hi Richard Hi, I just tried this model, unfortunately the Months arent getting impacted by change in Parameters. Were comparing to the previous year, so we need to jump back a year here. Reza. The delegation error is saying "the formula might not work correctly on large data sets". A measure was created that will correctly identify this but I plan on using a blank button to activate a bookmark which will trigger a table to filter to the Current Month to Date. I dont have any date column as such in my Model so I have to use Year column . I love all the points you have made. when i sort the x-axis according to month no, then the values on x-axis is displayed in this order- Jan 2017,Feb 2017 and Dec 2016(since month no of the specified months are 1,2 and 12 respectively). Nice technique using dates from fact table on the last n months visual. Using these functions are not too difficult. To learn more, see our tips on writing great answers. My question then is in which moment were getting some filtering on MaxFactDate so that this piece of code: What is a word for the arcane equivalent of a monastery? In the Show items when the value: fields please enter the following selections: 4. EDATE ( FDate, [N Value] ) get the last day of -N months But the problem am facing here is sorting the x-axis. While researching this problem, I found solutions which pointed to using the relative date feature which works. One as "In current month" and the other one is "Not in current month", for "In current month" i used Date.IsInCurrentMonth, now i need the same for "Not in Current Month". The solution you provided really helps me lot. The challenge about these reports is the rolling 13 months needs to be displayed on the visualizations, but the filter needs to include other months so users can still slice through them. Since we wanted to go from sales previous year to sales previous year quarter to date, we simply need to replace the Total Sales inside our Sales QTD formula to previous year (Sales PY) to get our Sales PY QTD. rev2023.3.3.43278. But if you were looking to understand the mechanics in my formula, MaxFactDate ignores the Date filter but respects the Sales[Date] filter. Hi SqlJason, He has a BSc in Computer engineering; he has more than 20 years experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. Date selection and filtering is such a crucial part of analytics today yet we all do an enormous amount of workarounds with custom columns and DAX to achieve SIMPLE things (like showing data relative to MY TIMEZONE for today consistent across PBI Desktop and Service). Hi Richard It also means that customers who stop trading with you will always show sales in the last 12 months and never go away. Showing month-to-date calculations to the current date (i.e. The issue I run into is that the measure now gets filtered out by the dates used in the calculated column on the table where the measure sits. 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. DATESBETWEEN ( Or Claims, if you're working with SharePoint. Thank you very much. All we have to do is jump to our Sales PY QTD and wrap some IF logic around it like so. 10:30am) is confusing for end-users, "today" data cannot be viewed on the report until after 10:30am (at which time the reported data changes under the user's feet). In the Service the dates are based on UTC time, we use reports which are built into dashboards to review the last 24 hrs, week, month etc. Thank you for providing the solution. Considering that today is 5th of May 2020. 5/5. The same option is available for the Relative Date Slicer, in the Date Range property of the slicer. Ive tried to recreate these items after looking through the pbix file. Can airtags be tracked from an iMac desktop, with no iPhone? However, when published up to the service, the relative date filter utilizes UTC timezone, and there's no way to account for this currently. 6. Quarter end date Dec 31,19 I want it in this way to be sorted Dec 2016(Dec 2015),Jan 2017(Jan 2016) and Feb 2017(Feb 2016) in the chronological order.Can this be done? Example : (1- (sales of current quarter / sales of previous quarter))*100 Ive come across the same issue myself when trying to show the value as a cumulative over months, MyMeasure = TotalLeaversYTD / NoOfPeople * (12 / n) Asking for help, clarification, or responding to other answers. Any ideas? can you not add an additional filter of is in this month and keep your existing filter of is in the last 1 months. And if i want to increase or decrease the span of time i would like to see i would have to adjust all formulas? Thanks this worked great except I cant get the calendar month and year to show in chronological order instead they show in alphabetical order. When I filter by "Relative date", and put "is in the last" and mark as "Include today" and choose the value "1" as shown below, after 9pm (Brazilian time), it marks as the next day . Rolling N Months for the Current Year Data Trend is working fine . Any help would be appreciated: http://community.powerbi.com/t5/Desktop/Show-sales-for-last-X-months-and-Same-Period-Last-Year/m-p/450197#M208415, your post was very helpful. Priscilla's focus is T-SQL, Data Warehousing, MS Power BI, and B.I. Cheers The relative date filters in Power BI is useless to anyone outside of UTC. I couldn't resist commenting. Assuming you date calendar and you are using date slicer as filter, Appreciate your Kudos. You can set the Anchor Date in the Date Range settings. But it does not work with 2 conditions. In this tutorial, Imgoing to show how you can solve this quite easily using DAX formulas. In a column, we can not use a slicer. Check if that format is available in format option. Yes as a slicer shown in Pic is what I wanted. anyone who has the same issue? I can choose last 12 calender months, but then the current month is not included. kindly revert. An "Include Current [Week; Month; Year]" option for the Calendar Weeks, Calendar Months and Calendar Years selections of the Relative Date filter. The bar charts accurately depict the sales value for the respective month/year however the order is not correct. We need to blank out this number if it's greater than this date. you can do that with adding offset columns into your date table, and use those in a slicer. But I have one more query if you could help.. Now I need to show growth for last n quarter on bar chart for different companies. This issue is also relevant / present for Power BI Report Server (i.e. DATESINPERIOD(Date'[Date],MAX(Date'[Date]),[NValue],MONTH) 6/5. for e.g. Really appreciate this article. at the same other card KPIs should show calculation for current week only. Thanks for contributing an answer to Stack Overflow! Create an account to follow your favorite communities and start taking part in conversations. Reddit and its partners use cookies and similar technologies to provide you with a better experience. Most of the techniques for doing the same use a disconnected date dimension along with the regular date dimension; however, using the same date dimension as a filter has the additional benefit that you can use all of the other measures also without any changes in the same report. Create a slicer Drag a date or time field to the canvas. This has been an incredibly wonderful article. I have end up with this solution and it works for me at any given time Choosing the type of slicer is in the slicer header, so if you cant see this option, better to check and see if your Slicer Header property is On. We then grab it and put it inside the table, and well see the results. 7/5. Also, please watch my video, which is a supplement to this blog. 3 BS Roll 12M = CALCULATE( [BS LTD], DATESINPERIOD( Calendar'[Date], MAX( Calendar'[Date]), -12, MONTH)). Either way, I would always recommend to use the value from the data source BEFORE the value you're trying to match against. Filter datatable from current month and current us GCC, GCCH, DoD - Federal App Makers (FAM). I might write a blog about that. With this blog tutorial, you will understand how to effectively manage time intelligence or time comparison-type information really well in all your Power BI reports. Akhil, did you find a way to get the MoM? Is there a possibility to filter likeI want? Is there any way to project last year values against current years months (Related Month of Current Year) in axis. Do you have any ideas on how to fix this please? Note that we are ignoring the date filter, only respect the date in Fact, Click to share on Twitter (Opens in new window), Click to share on LinkedIn (Opens in new window), Click to share on Facebook (Opens in new window), https://drive.google.com/file/d/10VJRgqhfm60g2lkpgxw59w8ieyjrj7nQ/view?usp=sharing, http://community.powerbi.com/t5/Desktop/Show-sales-for-last-X-months-and-Same-Period-Last-Year/m-p/450197#M208415, https://nablerin-my.sharepoint.com/personal/akhil_j_nabler_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fakhil_j_nabler_com%2FDocuments%2FLNRS%20Data%2FMOM%2Epbix&parent=%2Fpersonal%2Fakhil_j_nabler_com%2FDocuments%2FLNRS%20Data&slrid=32d1a59e-6010-7000-3bee-ff3004f06ea5. Any ideas welcome. Can you please share me the pbix file of this, Here it is https://drive.google.com/file/d/10VJRgqhfm60g2lkpgxw59w8ieyjrj7nQ/view?usp=sharing. Historical information is usually projected for the entire month. Ill use this formula for our Total Sales to demonstrate it. My sales measures actually compromise of calculations from 2 different sales tables. Runskey 230 Multiple Run skey -210,212,215,220, Sep 19 June 19 Mar 19 Dec 18 Sep 18 sales) every day of the week, then it will take last 12 months from their last sale, potentially artificially boosting their period numbers. Except- I need the last day to the be previous month, not the current month. CALCULATE (MAX ( Sales[Date] ), ALL ( Date )) ignore the selected date filter, and find the max of date in Sales table 7. Relative date filtering in a Power BI report is very simple using the Relative Date Slicer or Relative Date Filter, it gives you options to go back and forth on the selected period range from an anchor date with some extra options. and to make it bulletproof and definitely sort out ambiguity, you could do this: Keep up to date with current events and community announcements in the Power Apps community. Yep so we're now 3 years on and this bug (yes its a bug, not an issue) is still not fixed? I must be missing something. i have one doubt that what is MonthOfYear and MonthYearNo? Everything you need to know about Power BI: news, resources, and a community of super users ready to answer questions! SUM ( Sales[Sales] ), However I have a question regarding its mechanics. MaxFactDate <= MAX ( Date'[Date] ) In the Filter Pane, go to the Month Filter. Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. I was wondering if it would be possible to use the same tutorial with direct query. Sales (Selected Month) = SUM ( Sales[Sales] ) My Problem I have been using relative date filtering for a few reports recently on data sources from . as far as I understand reference to the MaxFactDate which will be somehow in this case equal to the date selected from slicer. ) if the date in the fact table is between the last N months, display Sales, else nothing. In the filter pane, under filter on this v isual, add today measure. She has 10 years of experience in the field of IT working as a Business Intelligence Analyst. You can filter your data to be in the past, future, or current using the first drop down of this slicer; You can use this switch to create a report of the current year, month, week, etc. The above slicer, is getting the last three months of data from 5th of Feb 2020 to 4th of May 2020. Year&month= (year)*100+monthno. "Is it before 10:30am? We need to blank out this number if its greater than this date. OK, will look into the what-if parameter. Here im Facing the challenge in calculation of sales for previous quarter. It's amazing that this cannot be done in 2021. So it has to be manually done and this adds a level of complexity when deploying solutions. Filter datatable from current month and current user. Sales (last n months) = By clicking Accept all cookies, you agree Stack Exchange can store cookies on your device and disclose information in accordance with our Cookie Policy. It is Friday, and I thought of writing a quick tip on how you can use the same date dimension for displaying the last N months (say, in a bar chart) and the data for selected month (say, in a card visual). Suppose I choose February 2017 and the n value is -3. then the chart should show for Dec 2016(Dec 2015),Jan 2017(Jan 2016) and Feb 2017(Feb 2016) in the chronological order but its not happening.The months mentioned in the brackets are for same period last year. Cumulative measure: 3/5. One thing I think this measure would give the same result: Reza is also co-founder and co-organizer of Difinity conference in New Zealand. You may watch the full video of this tutorial at the bottom of this blog. I am also working with same scenario where I have to display sales based in Year. Ive been trying it, but it has been imposible to show the data in the chart. https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35610880-fix-releative-date-slicer-utc-issue. Hi SQLJason, thanks for the tip but it doesnt work for me. The age of this ticket does not give me hope that Microsoft Power BI team cares much about the "other" half of the world - let's hope I'm wrong. Power BI Publish to Web Questions Answered. I ran through how you can effectively change your visualizations to illustrate the information in your Power BI reports in a compelling way. Create a filter Everything is working except for dynamically changing the number of columns that get displayed when the slicer connected to the N table is changed. I have been playing around with Jasons exampel as well but i am not able to find any differences from my model. . 4 2) Create 3 measures as shown below, and then add those 3 measures in the report along with a month slicer as shown below. https://nablerin-my.sharepoint.com/personal/akhil_j_nabler_com/_layouts/15/onedrive.aspx?id=%2Fpersonal%2Fakhil_j_nabler_com%2FDocuments%2FLNRS%20Data%2FMOM%2Epbix&parent=%2Fpersonal%2Fakhil_j_nabler_com%2FDocuments%2FLNRS%20Data&slrid=32d1a59e-6010-7000-3bee-ff3004f06ea5 . As you can see, I have a Date Column and a Month Year column. As you can see, our users can still navigate through the other months, but my reports are now showing a rolling 13 months. 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. I would love to utilize the Relative Date filter to handle things like current month, current year etc. @amitchandak Yes it is column , as I need to give user the flexibilty in a slicer to choose the month number to go back or forward. Learn how your comment data is processed. If you are using a date slicer in your Power BI report, a relative date slicer is one of the options to consider for sure. I am using multiple years of data, it shows me the January 2016 data instead of September 2018 and August 2018. However, that is not the reason why no data is being shown. So for instance, were now in quarter 4 and were only going to have information up to the last twenty days because in this example its the 20th of October. Do you know of a way we can resolve this? Why are physically impossible and logically impossible concepts considered separate in terms of probability? 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. MonthYearNo = RELATED ( Date'[MonthYearNo] ). @schoden , I am confused. For example, when I select Aug-2019 and N = 4 in slicer, i see sales bar correctly shown by month (May, Jun, Jul, Aug). Power Query - COUNTIFS copycat with performance issue. Its just a matter of understanding which one to use. Runskey 130 Multiple Run skey -1,120,130,125, Dec 19 Sep 19 June 19 Mar 19 Dec 18 He helps individuals and organizations develop data driven cultures and create enterprise value by delivering business intelligence training and education on Microsofts Power BI platform. I'd like to use the relative date filter. Theres plenty to learn around DAX formula visualization techniques. I want to see all the results of the current month + all data of the past 12 months. Sum of Sale 1400 1000 2000 310 500. THANKS FOR READING. Your condition is checking whether you have some data entered on the FIRST of the current month. How to organize workspaces in a Power BI environment? Post updated! Follow the steps below to recreate the same:-. Is there a way I can geta rolling avg and a rolling sum on top of this? In case it does not help, please provide additional information and mark me with @ Thanks. I assume it might be a case sensitive issue. Have you been using this slicer type? I get only a single column, but that column shows the correct number of items for the number of previous months selected, Figures I spend a day searching for a solution, only to discover answer after I post a question I didnt know about What If Parameter used to create the slicer Im good to go now. I tried this out and I am having issues with the arrangement of bar charts. Getting our users to "think in Greenwich time" when asking for "Today's Orders" via Relative date filtering is not viable. 2 nd field - 13. But I have not tested it. Not sure if this matters but below is the current measure that I am using to for a KPI: Any advice on if this is possible will be greatly appreciated. Are you sure that there are items in the list that simultaneously meet those conditions? document.getElementById( "ak_js_1" ).setAttribute( "value", ( new Date() ).getTime() ); This site uses Akismet to reduce spam. So if we were going off of today, it would look like: 6.31/2018-6.31/2019. Hoping you find this useful and meets your requirements that youve been looking for. Reza is an active blogger and co-founder of RADACAD. For instance, I use my [Date] column as a filter and choose the following: "Filter Type: [Relative Date] Show items when the value: [is in the last] [3] [calendar months]" Hi SqlJason I tried the upper and lower for case sensitive, and the datatable is still empty. If you choose Months (Calendar), then the period always consider full calendar months. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Thank you so much. Topic Options. I have tried it but the months are not filtered ? Let us create a What If parameter called N with values from 1 to 24, and increments of 1. 6 ) powerbi - Filter Dates which are NOT in current month using power Query - Stack Overflow Filter Dates which are NOT in current month using power Query Ask Question Asked 4 years, 5 months ago Modified 2 years, 8 months ago Viewed 5k times 0 in power bi's query editor, i needed a date column to be split into two more columns. VAR Edate = And this will lead you to the Relative Date Filter which gives you exactly the same features. I have tried several things already including the following: CALCULATE (SUM (Amount),Date [Date]<FIRSTDATE (PREVIOUSMONTH (Date [Date]))) Can anyone help me with this problem? Could you please explain it a little bit so that I could use it more consciously Other than that, I would also recommend you to not check against a display name. I am using below mention logic for the show the last 4 quarter data, (If [END DATE Period]=Dateadd(quarter,-4,Datetrunc(quarter,[Date Parameter])). 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). Is there anyway to do this with something other than a date ie a product type in a column chart? Labels: Labels: Need Help . RETURN I played with this feature and was able to come up with a trick. DICE Dental International Congress and Exhibition. He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. We (and Microsoft) have tried these solutions and many others, seems the solution requires the offset to be applied to the slicer for the relative date slicer to work using NZDT in the Service. It is also worth noting that our data in the Tabular model does not include a time component - just a date, so in this particular case there is no time calculations on the model's data - it's just that "Today" doesn't come until "midnight in Greenwich" passes (UTC+0:00). This basic capability for an Analytics tool is unusable in Power BI for half the countries in the world. Then write the Dax Expression: Today = IF (Sheet1 [Order Date]=TODAY (),1,0) Power bi date filter today. Thank you for this. 2 or even future (if you have that data in your dataset). I have weekly report with date slicer and have to created bar chart showing last 12 weeks from date selected, We set up a simple file to try all the ideas we had and found on the web. Before I show you the technique, let me show you an example of a finished report. 2021 YTD | 2020 YTD | 2019 YTD | 2018 YTD if yes, tell me about your experience, if no, tell me what you want which cant be done using this slicer. Relative Date Filtering- Prior Month. I am using the trend of 13 months using your logic . 2/5. In measure, we can. Dynamically Remove Columns In Power Query By Header Dates, Linear regulator thermal information missing in datasheet. I changed the data category as MAX/ MIN and worked. Find out more about the online and in person events happening in March! Press question mark to learn the rest of the keyboard shortcuts. When I replace the date with the product type the chart goes blank. The only thing I couldnt figure out is why my X axis is fixed but not dynamically presented. BEFORE YOU LEAVE, I NEED YOUR HELP. 1. I got everything working fine. Im Carl de Souza, a software developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI. (Creating the what if parameter).But, couldnt able to get the MOM. Then in the Filter function of the data table, after the date = Date(), Label.Text = 'Created By'.DisplayName. I explained a solution for the relative date slicer considering the local timezone here. Why do small African island nations perform better than African continental nations, considering democracy and human development? My Recent Blog -Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trendPower-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-RangesConnect on Linkedin. while calculating YTD % as in May, the value of n should be 5-3 = 2 (2nd from Apr) For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. 4) The main step for this technique is create a measure that will display the sum of sales for the last N months. 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. THANK YOU, AND LET'S KEEP LEARNING TOGETHER. ), Agreed, better and easier than mine. Click on the Modellin g tab -> New column from the ribbon. A place where magic is studied and practiced? Can you tell us more about this? 2. The same goes with quarter- t- date and year-to-date. Updating these reports to this setting was a pain, because I had to open and refresh all of my reports to do this. lets say that is the fruit picking date etc. My point I want to make a report based on the quarter end date and runskey (load of run).. By rejecting non-essential cookies, Reddit may still use certain cookies to ensure the proper functionality of our platform. FIRSTDATE ( ALL ( Calendar[Date] ) ), where n is the month for which the measure is being calculated This would mean introducing this formula to all the measures that i would like to filter this way, right? To help you understand my blog, below is the Date Dimension which is marked as a Date Table in Power BI Desktop. In this example, were comparing to the first 20 days of the quarter last year. A better solution would be to filter for user Principal Names. Making statements based on opinion; back them up with references or personal experience. It is important to know that putting the Month from the Date table will not work, so what we are going to do is create a month column in the Sales table and then use that as the axis for the bar chart. To illustrate this, Im going to work with 20 days into the current quarter. ), Rolling Measure: Please let me know if this works for you, and if you currently implementing another solution to the problem! Our company often like to review changes over 3 or 4 years past. Power Platform and Dynamics 365 Integrations. Go to Solution. The requirement that youre specifying is not understandable until we see what results youre trying to achieve here. Your email address will not be published. But if you add the same month field to the filter pane, it will now show Oct 2019 Oct 2020. 4/5. Required fields are marked *. How would i go about using the date axis here? How do you create the N? You can change the month in the slicer and verify that the measure values change for the selected month. Do you have any idea what is wrong? The slicer then changes the report at midday when its UTC midnight, frustrating for users as the report is different in the morning and afternoon. is there a way to do this? Filter ('Table Name', Date = Date (Year (Today ()), Month (Today ()), 1) && User ().FullName ='Created By'.DisplayName) If I do one condition at a time, the table populates. Home; About; Program; FAQ; Registration; Sponsorship; Contact; Home; About; Program; FAQ; Registration; Sponsorship . ENDOFMONTH(Date'[Date] ) get the last day of the month selected in the date filter Well, its always a little bit difficult to judge and provide the results without looking at the data structure and working of the PBIX file. But here the sorting happens in this way.Dec 2015, Jan 2016,Feb 2016,Dec 2016,Jan 2017 and Feb 2017. Do you have the same problem? Sam is Enterprise DNA's CEO & Founder. , Hi Jason. 5) Now create a bar chart with MonthYear on Axis and Sales (last n months) on the values, as shown below. 5 Thanks. Hi, I really loved this and appreciate it. Get Help with Power BI; Desktop; Relative Date Filter; Reply. Below, you can see that I have displayed 3 regular measures based on the selected month (Sales for selected month, Sales YTD and Sales Last Year) along with a bar chart that shows the sales for the last N months based on the selected month (special thanks to the folks at, 3) The next step is to make a measure that will display the last N months. Well the reason behind why its showing blanks is because you might not have included any date slicer onto that page and therefore its not able to recognize for which period to show the data into the column chart or in any charts or tables. https://docs.microsoft.com/en-us/power-bi/desktop-what-if. Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI. $100 | $92 | $75 | $110, I can get 2021 with std TotalYTD or Calculate(Sum( expression, filter) Have tried lots of work arounds, really need a slicer that you can set the offset in. Current output: Today = May 26, 2021 > Relative Date Filter (is in the last 1 month) = April 26, 2021 - May 26, 2021 Not sure if this matters but below is the current measure that I am using to for a KPI: CALCULATE ( TOTALMTD ( COUNTROWS ( Alerts ), Alerts [CreatedDate2] ) ) Any advice on if this is possible will be greatly appreciated. Hope that helps. This is a major drawback because my users in the Power BI Service would not be able to filter data on months outside of the rolling 13 months, as shown below. Relative date filtering is a great way to filter your data while keeping the current date in context. Place it in the chart as shown below. Is it possible to rotate a window 90 degrees if it has the same length and width? Having relative date reports that "clock-over to today" in the middle of the morning (e.g. Can you help me in achieving the MOM % trend. Tom. Great article I was looking for this kind of solution for a long time. I thought is there a way to use the relative date feature, but still allow my users to have access to the months outside of the rolling 13 months? If I hardcode in a name (mine or other users), the table works perfectly with the date filter. Relative date filter to include current month + la Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners, HR-Analytics-Active-Employee-Hire-and-Termination-trend, Power-BI-Working-with-Non-Standard-Time-Periods, Microsoft Power BI Learning Resources, 2023, Learn Power BI - Full Course with Dec-2022, with Window, Index, Offset, 100+ Topics, Formatted Profit and Loss Statement with empty lines, https://docs.microsoft.com/en-us/powerquery-m/date-fromtext, How to Get Your Question Answered Quickly.