Forum Discussion
Anonymous
6 years agoNot applicable
Previous 2 Quarters (Live Connection Dataset)
Hello,
I'm having trouble figuring out a measure to calculate the previous two quarter's revenue. This specifically will include the current quarter, and the quarter directly preceding it. Please note this is for a live connection.
Thanks
2 Replies
- Greg_DecklerCommunity Champion
If a live connection then I believe that means avoiding time intelligence functions. See if my Time Intelligence the Hard Way provides a different way of accomplishing what you are going for.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TITHW/m-p/434008 - TomMartensSuper User
Hey Anonymous,
is the live connection to SSAS Tabular or SSAS Multidimensional.
Regards,
Tom