Last 2 Quarters Measure

Is it possible to create a measure, which would show data from last two quarters? e.g. if today is April 8th, the time measure should return Q1 and Q2 of 2020.

Hi @Liudv
Welcome to the eazyBI community.

Yes, your use-case sounds possible using a calculated member from “Time” dimension.
You could aggregate the last two quarters in a new member and then use this member in the report

Aggregate({
  [Time].[Quarter].CurrentDateMember.PrevMember,
  [Time].[Quarter].CurrentDateMember
})

See more examples for calculated members on our Demo account
https://eazybi.com/accounts/1000/cubes/Issues/

Martins / eazyBI support

1 Like