I am trying to select the current date and go back in time one year, 365 days.
Would you know how could I do this through a MDX query?
Thanks in advance,
I think that's something like LASTPERIODS(365)
you can either use SAMEPERIODLASTYEAR or DATEADD
It seems that MDX is used in SSAS, here is Power BI forum.
For your requirement, You'd better post your thread to SSAS Forum to get more professional help.
If you need additional help about Power BI, please feel free to ask.
The MDX code is used in PowerBI to make a call of the last 365 days from SAP Business Warehouse.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.