SSAS MD Filter/Slicer on Current/Previous Time Period

[Anonymous]

We're working on recreating legacy reports in Power BI using SSAS Live Connect.  We're looking for a way to have them automatically roll forward at the beginning of a new period, be it year, quarter, month, etc.

Yes, we know we could do this with an import.  We need to add a calculation to the SSAS cubes to provide this functionality.

What we've tried so far:

Added current & previous hierarchies to the time dimension.  These work for regular measures, but break with any calculated measures that use the regular time dimension hierarchy.

Has anyone encountered this before?  What could we add to the cubes to select a relative date in Connect Live?

[v-chuncz-msft]

@Anonymous,

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/SAMEPERIODLASTYEAR-returns-bank/m-p/519802#M243083

[Anonymous]

We need to use Connect Live to the SSAS cubes, not import.  Can't do caluclations with Connect Live.

[Anonymous · Accepted solution]

We found the solution over with help at the SSAS forums:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9ed45165-2eb8-4f1a-b8ea-26ca768919eb/mdx-ii...