Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |