Forum Discussion
power query for YY-Q-n
hi,
can i kindly seek help on how to write the power query code to get info on Year-Quarter No (e.g. 2020-Q1, 2020-Q2, 2020-Q3)?
the columns for year & quarter are "Year" & "Quarter" respectively.
tks, -nik-
Add a custom column with this code
= Text.From([Year]) & "-" & Text.From([Quarter])Best regards
Phil
many tks, @PhilipTreacy
krgds, -nik
2 Replies
- PhilipTreacy
Super User
Add a custom column with this code
= Text.From([Year]) & "-" & Text.From([Quarter])Best regards
Phil
many tks, @PhilipTreacy
krgds, -nik