Show data by quarter

I’d like to show data based on the completed quarters in this year (i.e., Q1, Q2 and Q3 2023), because I want to show a stacked bar graph, but Q4 is misleading because it’s not complete.

Hi @JoshHC,

If you want to show the completed quarters of this year, you might filter them to see if they have been completed.
The expression for the calculated member within the default hierarchy in Time dimension might look as follows.

Aggregate(
 Filter(
--quarters of this year
  [Time].[Year].CurrentDateMember.Children,
--filter condition - already ended 
  DateAfterPeriodEnd(
   "now",  
   [Time].CurrentHierarchyMember)
))

Since the new year is coming, you might need completed quarters of current and the previous year as well.
The expression in that case might be as follows.

Aggregate(
 Filter(
--quarters of this and previous year
  {[Time].[Year].CurrentDateMember.PrevMember.Children,
   [Time].[Year].CurrentDateMember.Children},
--filter condition - already ended 
  DateAfterPeriodEnd(
   "now",  
   [Time].CurrentHierarchyMember)
))

Just in case - the expression for the rolling last 4 completed quarters might be as follows.

Aggregate(
  [Time].[Quarter].DateMembersBetween(
    "15 months ago",
    "3 months ago"
  )
)

Regards,
Oskars / support@eazyBI.com