Forum Discussion
Helper IVLast financial year to date
Hi maurcoll ,
I understand you are facing an issue with calculating last financial year to date. For a more robust approach, I would do it like this :LFYTD =
CALCULATE (
[Total Calls],
DATESBETWEEN (
'Date'[Date],
DATE (YEAR (TODAY ()) - 1, 4, 1),
DATE (YEAR (TODAY ()) - 1, MONTH (TODAY ()), DAY (TODAY ()))
)
)⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]
Super UserHi maurcoll ,
I understand you are facing an issue with calculating last financial year to date. For a more robust approach, I would do it like this :
LFYTD =
CALCULATE (
[Total Calls],
DATESBETWEEN (
'Date'[Date],
DATE (YEAR (TODAY ()) - 1, 4, 1),
DATE (YEAR (TODAY ()) - 1, MONTH (TODAY ()), DAY (TODAY ()))
)
)
⭐Hope this solution helps you make the most of Power BI! If it did, click 'Mark as Solution' to help others find the right answers.
💡Found it helpful? Show some love with kudos 👍 as your support keeps our community thriving!
🚀Let’s keep building smarter, data-driven solutions together! 🚀 [Explore More]
Helper IVThat has worked thank you