How to exclude current quarter in Time dimension

I am currently using the regular quarter hierarchy member in the time dimension - this works exactly how I want the report to, however i would like it to exclude the current quarter because it shows incomplete data.

image

Hi @ormcg

If you go the regular hierarchy “All times” > Years > Quarters etc. eazyBi will show all the members imported in the cube.
If you don’t want to show the current or future periods, here is what you can try:

  1. create a new calculated measure using this formula:
CASE 
  WHEN
  DateInperiod(
    'today',
    [Time].CurrentHierarchyMember
  )
  OR 
  DateBeforePeriodEnd(
    'today',
    [Time].CurrentHierarchyMember.Prevmember
  )
  THEN 0
  ELSE 1
END
  1. select (temporarily) this new measure in the report columns (switch to table view for this step).
    It will return 1 for periods until current period.

  2. filter the report by this column (new measure name > 0). That will hide the current period from the report.

  3. remove the column with new calculated measure

Martins / eazyBI

1 Like