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.


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:
  THEN 0
  ELSE 1
  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