Power Platform Community Forum Thread Details

Hello everyone,

So I had written a filter formula that filters data based on the result of a comparison between the number of the current quarter and that of last quarter. This no longer works because the current quarter is in a different year from last quarter. I've tried to use

RoundUp(Year(Today())*12+Month(Today()/3),0) = RoundUp(Year(ThisItem.Created)*12+Month(ThisItem.Created)/3,0) - 1, but it doesn't work.

This is an excerpt of my formula...

Switch(
 dpd_Reports_PeriodOptions.Selected.Value,
 "This Week",
 WeekNum(Created) = WeekNum(Today()),
 "Last Week",
 WeekNum(Created) = WeekNum(Today() - 7),
 "This Month",
 Year(Created)*12+Month(Created) = Year(Today())*12+Month(Today()),
 "Last Month",
 Year(Created)*12+Month(Created) = Year(Today())*12+Month(Today())-1,
 "This Quarter",
 RoundUp(
 Year(Created) * 12 + Month(Created/3),
 0
 ) = RoundUp(
 Year(Today()) * 12 + Month(Today()/3),
 0
 ),
 "Last Quarter",
 RoundUp(
 Year(Created / 3) * 12 + Month(Created / 3),
 0
 ) = RoundUp(
 Year(Today()) / 3 * 12 + Month(Today()) / 3,
 0
 ) - 1,
 "Specific Period",
 Created >= dpc_Reports_StartDate.SelectedDate && Created <= dpc_Reports_EndDate.SelectedDate + 1
 );

How can I resolve this?

Categories:

Connecting to Data

General Questions