Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Good afternoon,
I have an issue where my company uses a Retail Calendar (4-5-4), however, here is the sticky part. Each FY starts on a different day, always a Friday.
For example, FY2019, started on 2018-12-28 and ends on 2019-12-26.
Fiscal 2018, started on 2017-12-29 and ended on 2018-12-27.
We also have show data relative to the day of the week last year. In other words, if I am looking at today, 2019-10-28, I would need to compare to 2018-10-27. I can do that in standard Time Intelligence, the problem I have having is PYTD and PPTD.
Now to my question, any clue how I can determine the previous YTD, PTD numbers?
Solved! Go to Solution.
@Anonymous
For any time intelligence function, you could implement a custom DAX formula.
@Anonymous
For any time intelligence function, you could implement a custom DAX formula.
Sorry, been there, Friday is not included as an option as a start of the week.
Sorry, also PRIOR YTD and PRIOR PTD.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |