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 ...
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

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