Add a Letter infront of a Nummer in PowerQuery

[Wolfi]

Hello to everybody,

How can I add a letter infront of number at Power Query?

I have a Quater column  and would lig to create a new custom colum and add a "Q" in front of the quarter number.

Final result: Q#

The DAX formula will be: = "Q"&FiscalQuarter(column name)

I want to do it , before the import into Power Bi

Many Thanks for your help

Wolfgang

[Smalfly]

Hi @Wolfi ,

try this: 

"Q" & Text.From(Date.QuarterOfYear([your date column name]))

[Wolfi · Accepted solution]

Thanks a lot to all for your suppport and help

Final Solution: "Q"&Text.from(FiscalQuarter)

Has had some probles with some emty cells as well! Now it is working

[jgordon11]

= Table.AddColumn(PreviousStepName, "NewColumName", each "Q" & Text.From([Quarter]))

change PreviousStepName, "NewColumnName", and [Quarter] to match your query