Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Just wanted to share this, as I was finding a lot of what appeared to be very complex (to me at least) solutions for something pretty simple - displaying the financial year, in a format of choice, based on a date.
Steps:
if [doc_startdate] = null then "" else if [doc_startdate] < #date(2020,7,1) then "2019-20" else if [doc_startdate] < #date(2021,7,1) then "2020-21" else if [doc_startdate] < #date(2022,7,1) then "2021-22" else if [doc_startdate] < #date(2023,7,1) then "2022-23" else if [doc_startdate] < #date(2024,7,1) then "2023-24" else "ERROR"
Done!
Hope that it helps someone 🙂