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.
How can I do same formula than Sameperiodlastyear in Direct Query ?
I have sales regarding 2 dates segment filter.
I yould like to have same result regaring last 2 dates year.
Hi @Nibz,
You are able to use Sameperiodlastyear function in DirectQuery mode as long as you enable “Allow unrestricted measures in DirectQuery mode” in Power BI Desktop. You can review example in the following screenshots.
Thanks,
Lydia Zhang
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 |
---|---|
107 | |
98 | |
78 | |
66 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |