Hi Everyone, I’ve got data set with the client name and their service start and end date (end date can be futuristic as well). I have a table which contains a list of projects with a start and end date and a number of people needed to deliver the project. I regularly follow this, I have a similar issue.

Using this method, you can get all transactions that fall in between those two separate transaction date fields. I have a Gallery which i filter by a selctede Date from DatePicker controll.

Any suggestions? But the to date is always the maximum. If you want to learn more about Power BI, Read Power BI from Rookie to Rock Star. Power Platform Integration - Better Together! Power Platform and Dynamics 365 Integrations, Power Apps Community Demo Extravaganza 2020, Business Value Webinars and Video Gallery, 2019 Microsoft Business Applications Summit Recordings (Archived), Microsoft Business Applications Summit 2020 Session Recordings. I need to generate a visual which sums the volume of people needed on these projects looking into the future to create a demand line. Power BI date slicers can be used to filter based on one field. Hope this resolves that. I have a Table with StartDate and EndDate columns. What is Premium Per User License for Power BI, and What is it good for? Power Platform and Dynamics 365 Integrations, Power Apps Community Demo Extravaganza 2020, Business Value Webinars and Video Gallery, 2019 Microsoft Business Applications Summit Recordings (Archived), Microsoft Business Applications Summit 2020 Session Recordings. In that case, you’d most probably want to use the slicer to filter the report in such a way that it shows all data in between the start and end date. I have a calendar and a gallery on a screen in my PowerApp. Reza, Thanks for the blog!

I assume you are using the GetEventsCalendarViewV2 of the Office365 Outlook connector.
If that doesn't immediately help, I would start a new post on this forum with the results you are seeing.

Active clients means, those clients who’s 1. end date is greater that today 2.

And now, we have the BEFORE and AFTER slicer simply working for Start and End date: The simple method that I showed here works for both custom date table or the default date table. Reza, 20 (Tuesday) 5:00 am - 23 (Friday) 9:00 am, 17 (Tuesday) 5:00 am - 20 (Friday) 9:00 am.

End date is missing and lastly. Retrieves the current date and time, and displays it as a string. Reza. Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event. Featuring samples like Return to the Workplace and Emergency Response Applications, Features releasing from October 2020 through March 2021.

I want to create a gallery that will show the last 30 days of items submitted using a specific incident type.

Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant.

If you have issues with the 'Start Time' not showing up, try the EventDate.
The client would to be able to filter the gallery by using the date range that's in red and blue. Ok, if it's a SharePoint list then your calendar list will have a column defined - Start Time  (which is really EventDate behind the scenes), Filter(yourDataSource, 'Start Time' >= _selectionStart && 'Start Time' <= _selectionEnd). Meaning I need the records whose StartDate would fall in the ‘From’ and ‘To’ window and the same thing i.e.

Then i try to do as below. Can you elaborate more?

I have added one slicer for Start Date.

The same approach would work for custom date tables too. Your scenario is the subscription pattern, which I explained here in detail. Power Platform Integration - Better Together! Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event. More details about Filter function in PowerApps, please check the following article: but this way you don't have problems with the delegation? The same approach would work for custom date tables too. I need to see the data rows to get a feeling of what you are after.

Then I have changed the type of it, using this option: Now my Start Date slicer looks like this: I can adjust the from date.