Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
77 | |
74 | |
62 | |
61 | |
45 |
User | Count |
---|---|
108 | |
102 | |
93 | |
83 | |
64 |