Any idea how I can make my X axis dynamic like yours here? 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. by | Jun 9, 2022 | prayers of dedication presbyterian | advance australia national director | Jun 9, 2022 | prayers of dedication presbyterian | advance australia national director I also tried using the Office365Users function instead. But if you add the same month field to the filter pane, it will now show Oct 2019 Oct 2020. 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. In the screenshot above in the Relative Date Filter you have seen that it also has the option to include today or not. Other than that, I would also recommend you to not check against a display name. 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. What is a word for the arcane equivalent of a monastery? If I hardcode in a name (mine or other users), the table works perfectly with the date filter. 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. 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. I am having the same problem. 6/5. Any ideas? First, we need to work out the previous year sales. 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. What Is the XMLA Endpoint for Power BI and Why Should I Care? He is a Microsoft Data Platform MVP for nine continuous years (from 2011 till now) for his dedication in Microsoft BI. Do you have any ideas on how to fix this please? The requirement that youre specifying is not understandable until we see what results youre trying to achieve here.

Low Income Senior Housing Topeka, Ks, What Happened To Motown Noah, Articles P