Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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,
Regards,
Hi @Anonymous,
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.
Best Regards,
Cherry
Hi Cherry,
The MDX code is used in PowerBI to make a call of the last 365 days from SAP Business Warehouse.
Thanks
Hi @Anonymous
I think that's something like LASTPERIODS(365)
- Quentin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |