Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.2k views
in Technique[技术] by (71.8m points)

powerbi - Change column display in Power BI power query

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...