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.
Over the last few months I have created multiple dashboards using DirectQuery. Within the dashboards I used the "SAMEPERIODLASTYEAR" function and it worked without any problems. I recently had my computer reimaged. I reconnected all the dashboards and now some of my visuals won't display because the "SAMEPERIODLASTYEAR" fucntion is not compatible in DirectQuery. Has something changed within Power BI? Is there a trick to getting this to work? Thanks in advanced for your help.
Solved! Go to Solution.
Hey,
maybe enabling this option will resolve your issue
Maybe this document will also be of interest
And also this site may be of interest, there are a lot of examples available how to rewrite TimeIntelligence functions, if these functions are not available (this site has been responsible that I write all my DAX statements without the usage of special timeintelligence functions :-))
http://www.daxpatterns.com/time-patterns/
Hope this helps
Hey,
maybe enabling this option will resolve your issue
Maybe this document will also be of interest
And also this site may be of interest, there are a lot of examples available how to rewrite TimeIntelligence functions, if these functions are not available (this site has been responsible that I write all my DAX statements without the usage of special timeintelligence functions :-))
http://www.daxpatterns.com/time-patterns/
Hope this helps
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 |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |