Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 🙂
Check out the July 2025 Power BI update to learn about new features.