I have two elements, let' say for example "KPI before 2020" and "KPI after 2020".
I would like to create a cube view that's shows
>>> only "KPI before 2020" when my POV time is <=2019M12
>>> only "KPI after 2020" when my POV time is >=2020M01
Currently my cube view result looks like:
My desired outcome:
Any ideas how to create such cube view?
Probably due to rubber duck effect I found a solution after I had written my question here.
A#MyKPIs.Base.Where(Text1 Contain 'Active')
Despite I solved the problem, I would highly appreciate alternative solutions.