Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
User | Count |
---|---|
126 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |