powerbi - Change column display in Power BI power query

Question

I have a fiscal year column, fiscal period, and fiscal quarter. The Fiscal Quarter column is calculated by dividing the fiscal period by 3 then rounding up the number. As a result, the values in this column appear as 1, 2, 3,...etc.

I want to change how the values appear so that they are displayed as "Qtr - FY" (e.g, Q1 - FY2021) in the same column that contains the calculation formula, preferably by getting this info from the available columns. Any idea how to do this?

question from:https://stackoverflow.com/questions/65879271/change-column-display-in-power-bi-power-query

Answer 1

I think you are looking for CONCATENATE

CONCATENATE(<text1>, <text2>)  

Concatenate multiple columns:

=CONCATENATE( [FirstName]&" ", CONCATENATE( IF( LEN([MiddleName])>1, LEFT([MiddleName],1)&" ", ""), [LastName]))

To add static values in between columns, follow this.

= "Q" & [fiscal quarter] & " - FY" & [fiscal year]  

Read more on How to concatenate multiple column in Power BI