Forum Discussion
Error with PREVIOUSMONTH with calculated column
yolanda_meng i got bad news. Now the PREVIOUSMONTH is not supported into Directquery.
take a look in this article, and you will see: "This DAX function is not supported for use in DirectQuery mode. For more information about limitations in DirectQuery models, see http://go.microsoft.com/fwlink/?LinkId=219172."
After your see this article i reccomend you to see the second link, to see all limitations with DAX. It has been changed probally in this last update.
don't forget to mark this post as solution, other people can have the same situation in the future.
yolanda_meng i got bad news. Now the PREVIOUSMONTH is not supported into Directquery.
take a look in this article, and you will see: "This DAX function is not supported for use in DirectQuery mode. For more information about limitations in DirectQuery models, see http://go.microsoft.com/fwlink/?LinkId=219172."
After your see this article i reccomend you to see the second link, to see all limitations with DAX. It has been changed probally in this last update.
don't forget to mark this post as solution, other people can have the same situation in the future.
henriquesilveirAhhh, puzzle solved with sad news...but thanks so much for you help! I will mark this as a solution.
Thanks a lot!
Follow up question henriquesilveir, is there a known measure that could replace PREVIOUSMONTH and acheive what it can do? Most likely other users come across this issue will have the same questions :)
I could use this post:
https://community.powerbi.com/t5/Desktop/direct-query-previous-month/td-p/205439The issue is to replace the PreviousMonth into other DAX to do the same thing... i hope that if helpfully!