https://community.fabric.microsoft.com/t5/Power-Query/Function-DATESINPERIOD-doesn-t-work-properly/m-p/4399897
Solved: Re: Function DATESINPERIOD doesn't work properly - Microsoft Fabric Community
Jun 23, 2025 - Hi To calculate the Rolling 12-month sum on monthly amounts instead of cumulative amounts, you need to aggregate monthly values first and then apply
microsoft fabricsolvedfunction
https://community.fabric.microsoft.com/t5/Desktop/Cant-get-Today-to-work-with-Datesinperiod/m-p/3314876
Solved: Re: Cant get Today to work with Datesinperiod - Microsoft Fabric Community
Jul 4, 2023 - Hi Thanks again for your help. I got it to work - i was missing the .[date] after chosing the datesinperiod date
get today
https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/DATESINPERIOD-shows-dates-beyond-the-maximum-date-in-the-data/m-p/3036119/highlight/true
Solved: Re: DATESINPERIOD shows dates beyond the maximum d... - Microsoft Fabric Community
Jan 22, 2023 - Thanks for helping. In my opinion however the result after removing .[Date] form the DAX is not as expected. I would expect the first chart you