Filter current previous year's quarters in time series that filled the missing data with TimeDim

[former_member1352663]

Hi everyone,

I'm new in the WeBI and the BO reports. I have a TimeSeries datetime dimension, that misses some dates. I filled the dates using the TimeDim function as following:

Time Series Completed =TimeDim([TimeSeries];QuarterPeriod)

and then I created these two dimensions:

Current Year = FormatDate([Time Series Completed];"yyyy") and

Quarter = FormatDate([Time Series Completed];"qQ")

I created the vertical table I wanted by drag and drop the Current Year and the Quarter and I get the following table

From this table I want to present only the 2022 and 2021 quarters. I create a new measure

Till Previous Year Completed = ([Current Year Completed] >=(Max(FormatNumber(Year(RelativeDate([Year Completed];-366));"####")) In Report))

and I used it in the table like this

but then I get the following result:

Do you have any suggestion as how to solve this?

[former_member27]

Hi vasouli,

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get the most out of your community membership, please consider including a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Profile https://developers.sap.com/tutorials/community-profile.html

Tips for Questions: https://community.sap.com/resources/questions-and-answers

Consider taking our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of the SAP Community!

All the best,

Dedi

[former_member27]

Hello again, vasouli,

I'm glad to see you got an answer to your question! If it helps you, please make sure to accept (you'll see the "accept" option beneath the question) -- so members with similar issues will be able to find a solution to their problems too.

If it doesn't help, you can always leave a comment providing more details that can guide members who wish to assist you.

I hope that this guidance is useful -- and we look forward to your next question for the community!

All the best,

Dedi

[krisa24 · Accepted solution]

Hi,

do you want dynamic filter(last 2 years) or just to select year 2021 and 2022?

I would not overcomplicate it in case of static filter and simply I would choose the requested years.

For dynamic time filters I like to use CurrentDate() function.

Last year = Year(CurrentDate()) - 1

Then you apply filter to the appropriate object select only values >= [Last Year]

[former_member1352663 · Accepted solution]

I want actually the dynamic filter. I will try it with last year, but I think the problem is in the TimDim which fill the missing quarters, because the [Till Previous Year Completed] actually works the same way with the dynamic filter. Thanks anyway!!!