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