renatoromao This formula calculates the difference between the "CreatedDate" and "ClosedDate" fields in minutes using the "DateDiff" function. 365-Assist* I see that the question was marked as solved, but it wasnt really solved whatsoever you still have a situation with it. Message 2 of 15 4,063 Views 1 Reply v-xida-msft Returns a DateTime value with the month portion incremented by n months. Do you think that you could post your updated question on the official Power Query forum? CFernandes To get the model, see DAX sample model. The content that you'll see here is mostly written by me (Miguel Escobar) and it's mostly related to Data Preparation and Data Analytics in general. Life-to-date represents the accumulation of a measure over time since the very beginning of time. Indicates whether the given datetime value dateTime occurs during the next number of weeks, as determined by the current date and time on the system. Thats why creating your own custom function to handle such scenario would be the best way to go, since theres really nothing out of the box that can do this for you. We are so excited to see you for the Microsoft Power Platform Conference in Las Vegas October 3-5 2023! Power Apps Samples, Learning and Videos GalleriesOur galleries have a little bit of everything to do with Power Apps. Is there such a thing as "right to be heard" by the authorities? I have a specific date, and I want to look this up to return a value against two dates. Let me know if you have any questions or need further assistance. In regards to something like exclude weekends, creating a custom function based on the List.Dates would be the best thing to do. Power Apps Samples, Learning and Videos GalleriesOur galleries have a little bit of everything to do with Power Apps. All, I am trying to run a Get Items action using a Filter query to obtain results between my StartDate and EndDate for 7 days out as such: StartDate ge (utcnow ()+7),'dd-MM-yyyy') and Enddate lt (utcnow ()),'dd-MM-yyyy')) this is giving me the following error: Now I want to check whether the project submission date was between the project start and project end date or not. There are a host of features and new capabilities now available on Power Platform Communities Front Door to make content more discoverable for all power product community users which includes The next step is just to add a custom column. iAm_ManCat Date.DatesBetween to retrieve dates between 2 dates in Power BI and Power Query Today I'm sharing a handy function with you that allows you to retrieve all or just a couple of dates between 2 given dates: Date.DatesBetween.
