Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I need advice on why my YTD (this year) is showing data for 1 Jul 2020 to 2 Jul 2020, while my YTD (last year) is showing data for all of Jul 2019? Shouldn't it be showing data for 1 Jul 2019 to 2 Jul 2020?
kind regards
arnie
Solved! Go to Solution.
Hi Everyone,
I have worked out the DAX that resolves all MTD LY, QTD LY and YTD LY. Added bonus was creating the 4th LY measure that was based just on any actual date of the year. Here goes:
Hi Everyone,
I have worked out the DAX that resolves all MTD LY, QTD LY and YTD LY. Added bonus was creating the 4th LY measure that was based just on any actual date of the year. Here goes:
YTD, should show from Jan first to today.
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
Hi @stevedep
My apologies for not being clear, my YTD calculations are based on the financial year, starting Jul.
kind regards
arnie
Create a date table identifying your fiscal years. Will assist you greatly in the long run. Then you're able to create measures based off of your fiscal qtrs and years opposed to jan-dec. Just a tip.
Hi @AlexAlberga727 , thanks for the advice. Yes, I am currently using a date table that identifies my fiscal years. Still getting stuck with the DAX for some reason.
Can you share your DAX codes so we can help?
Proud to be a Super User!
Awesome Keyboard Shortcusts in Power BI, thumbs up if you like the article
My Community Blog Articles (check them out!)
My Blog - Power M code to automatically detect column types -
How to create test data using DAX!
User | Count |
---|---|
51 | |
36 | |
20 | |
14 | |
13 |
User | Count |
---|---|
94 | |
72 | |
30 | |
21 | |
13 |