@RezaDorrani
Hey, I checked out your Youtube channel and plan to go over more of your videos.
So after beating my head against the wall for a few days this is all I could come up with.
The first Filter, which is not working. i'm not sure if it has something to do with collection
Filter('Expense App List New',Created = Year_Filter_Dropdown.Selected.Year)
The second Filter only half works. This Week, This Month, and Year To Date work. I cant get the Quarters to work. I'm not sure what I have to add to the ends of them (similar to the Month string.)
Edit: Also I'm not sure if using a filter for the Created field can be Delegable.
Switch(
Date_Filter_Dropdown2.Selected.Value,
"This Week",
Filter('Expense App List New',Created>=DateAdd(Today(),If(Weekday(Today())<>1,-Weekday(Today())+2,-6),Days) && Created<DateAdd(Today(),If(Weekday(Today())<>1,9-Weekday(Today()),0),Days)),
"This Month",
Filter('Expense App List New',Year(Created)=Year(Today()) && Month(Created)=Month(Today())),
"Q1",
Filter('Expense App List New',Year(Created)=Year(Today())),
"Q2",
Filter('Expense App List New',Year(Created)=Year(Today())),
"Q3",
Filter('Expense App List New',Year(Created)=Year(Today())),
"Q4",
Filter('Expense App List New',Year(Created)=Year(Today())),
"Year To Date",
Filter('Expense App List New',Year(Created)=Year(Today())),
'Expense App List New'
)
The third Filter works good.
Sort(
Filter(
'Expense App List New',
IsBlank(Common_Supplies_Filter_Dropdown2.Selected.Supplies)||
CommonSupplies = Common_Supplies_Filter_Dropdown2.Selected.Supplies
),
ID,Ascending
)
And in the end I still need to combine all three formulas into one. for my data table.
Any more help will be greatly appreciated.
