Joining up 2 columns only want the first part of year

[Jay2022]

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 ?

[ronrsnfld · Accepted solution]

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

[ronrsnfld · Accepted solution]

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.

[Jay2022]

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

[ronrsnfld · Accepted solution]

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.

[Jay2022]

Thank you

[Jay2022]

and the mid ?

[ronrsnfld]

What about MID don't you understand?

[Jay2022]

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 ?

[ronrsnfld · Accepted solution]

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.

[ronrsnfld · Accepted solution]

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