Forum Discussion

Wolfi's avatar
Wolfi
New Member
3 years ago
Solved

Add a Letter infront of a Nummer in PowerQuery

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

Need Help
  • Wolfi's avatar
    Wolfi
    3 years ago

    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

3 Replies

  • Smalfly's avatar
    Smalfly
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    Hi Wolfi ,

     

    try this: 

     

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

    • Wolfi's avatar
      Wolfi
      New Member
      3 years ago

      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's avatar
    jgordon11
    Icon for Resolver II rankResolver II
    3 years ago

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

     

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