sameperiodlastyear - Robuta Search

https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-for-measure-with-page-slicer/td-p/2644546 Solved: SAMEPERIODLASTYEAR for measure with page slicer - Microsoft Fabric Community Jul 19, 2022 - Solved: I'm struggling with same period last year where the page has a slicer on it, seen various articles saying this might be an issue but none of microsoft fabric solved measure slicer community https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-for-measure-with-page-slicer/m-p/2647945 Solved: Re: SAMEPERIODLASTYEAR for measure with page slice... - Microsoft Fabric Community Jul 19, 2022 - Yes, it could be. Try adding a REMOVEFILTERS on the table which the slicer is coming from microsoft fabric solved measure https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-DATESYTD-different-from-DATESYTD/m-p/600116/highlight/true Solved: Re: SAMEPERIODLASTYEAR(DATESYTD( )) different from... - Microsoft Fabric Community May 7, 2019 - Thanks Yeah, I don't like them much either. They kinda shady. Let's see if can enlighten us then, as usual. I would give you kudos but it's not different from microsoft fabric solved community https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-DATESYTD-different-from-DATESYTD/m-p/596311/highlight/true Solved: Re: SAMEPERIODLASTYEAR(DATESYTD( )) different from... - Microsoft Fabric Community May 7, 2019 - Perhaps very knowledgeable people like , , would care to chip in? Many thanks different from microsoft fabric solved community https://community.fabric.microsoft.com/t5/forums/filteredbylabelpage/board-id/DAXCommands/label-name/sameperiodlastyear Topics with Label: Sameperiodlastyear - Microsoft Fabric Community microsoft fabric topics label community https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-not-giving-correct-results/m-p/5125150/highlight/true Solved: Re: SAMEPERIODLASTYEAR not giving correct results - Microsoft Fabric Community Mar 4, 2026 - Hi, Your formula is correct. Do one of the following: Ensure that your Calendar goes only until today; or Create a Date slicer from the Calendar microsoft fabric solved giving correct results https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-for-measure-with-page-slicer/m-p/2647726/highlight/true Solved: Re: SAMEPERIODLASTYEAR for measure with page slice... - Microsoft Fabric Community Jul 19, 2022 - Try LYVolAll = CALCULATE ( [VolAll], TREATAS ( VALUES ( Dates[DateLY] ), Dates[Date] ), REMOVEFILTERS ( Dates ) ) I think the TREATAS is being added microsoft fabric solved measure https://community.fabric.microsoft.com/t5/Desktop/Substitute-for-SAMEPERIODLASTYEAR-which-will-work-for-non/m-p/4922534/highlight/true Solved: Re: Substitute for SAMEPERIODLASTYEAR() which wil... - Microsoft Fabric Community Feb 1, 2026 - I refined your code with AI assistance (so please check carefully). I am pretty sure you could use EOMONTH() instead of your lunar year calculations. microsoft fabric solved substitute wil community https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-with-filters-Year-Month-Day/m-p/2491293/highlight/true Re: SAMEPERIODLASTYEAR with filters Year,Month,Day - Microsoft Fabric Community May 3, 2022 - Thanks for answering. Maybe I didn't explain well. The problem is if I apply a filter with the slicers from the "page2". If you select e.g: with filters microsoft fabric year month day https://support.microsoft.com/id-id/topic/kb3213709-memperbaiki-fungsi-sameperiodlastyear-tidak-berfungsi-dalam-kueri-dax-di-sql-server-2016-analysis-services-8753bce6-c72e-6a5e-6ee5-bbce2cfd64c4 KB3213709-memperbaiki: fungsi SAMEPERIODLASTYEAR tidak berfungsi dalam kueri DAX di SQL Server 2016... Memperbaiki masalah di mana fungsi SAMEPERIODLASTYEAR tidak berfungsi dalam kueri DAX di SQL Server 2016 Analysis Services. https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-not-giving-correct-results/m-p/5125059/highlight/true Solved: Re: SAMEPERIODLASTYEAR not giving correct results - Microsoft Fabric Community Mar 4, 2026 - Why you are getting full month instead of three days. The issue is that your slicer is selecting the full month, so: SAMEPERIODLASTYEAR shifts the microsoft fabric solved giving correct results https://community.fabric.microsoft.com/t5/Desktop/SAMEPERIODLASTYEAR-with-a-year-filter/m-p/2403222 Solved: Re: SAMEPERIODLASTYEAR with a year filter - Microsoft Fabric Community Mar 18, 2022 - I couldn't get this work, but doing it this way resolved the issue. CALCULATE ( [Measure] , FILTER ( ALL ( Dates ), Dates[Year] = SAMEPERIODLASTYEAR with a microsoft fabric solved year filter