cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II

## Joining up 2 columns only want the first part of year

QTR Year = 'Fiscal Calendar'[Fiscal Qtr] & " "& " " & 'Fiscal Calendar'[Fiscal Year]

Fiscal Qtr = Qtr 1 (etc)

Where fiscal year is like so 2023/24

Curretly shows as Qtr 1 2023/24

How do i get it to show like Qtr 1 23/24 ?

3 ACCEPTED SOLUTIONS
Super User
Qtr Year = [Fiscal Qtr] & " " & MID([Fiscal Year],3,99)
Super User

Maximum number of characters to return. It doesn't matter if it is greater than the length of the rest of the word. Given your fixed length, it could just as easily be replaced by any number from five (5) or greater. AAMOF, I will change it to five now.

Super User

Your question implies a lack of knowledge as to how functions are used to create formulas. For the MID function in particular, I suggest you do an internet search for the MID function (in the DAX language, as used here). For the creation of formulas from functions, and the use of functions as a component of a formula, I'm afraid I don't have a good resource to recommend. Maybe someone else does.

8 REPLIES 8
Helper II

ant to know what it is doing in this formula please ?

Super User

Your question implies a lack of knowledge as to how functions are used to create formulas. For the MID function in particular, I suggest you do an internet search for the MID function (in the DAX language, as used here). For the creation of formulas from functions, and the use of functions as a component of a formula, I'm afraid I don't have a good resource to recommend. Maybe someone else does.

Helper II

Thank you

Helper II

and the mid ?

Super User

What about MID don't you understand?

Helper II

This is great thank you.  For a bit of contect I can tell the 3 says start from 3 values in eg the first 1 in 2016/17 but what does the 99 referenmce please ?

Super User

Maximum number of characters to return. It doesn't matter if it is greater than the length of the rest of the word. Given your fixed length, it could just as easily be replaced by any number from five (5) or greater. AAMOF, I will change it to five now.

Super User
Qtr Year = [Fiscal Qtr] & " " & MID([Fiscal Year],3,99)

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

#### Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

#### Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors