Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie:
danutza_84 pe Simpatie
 | Femeie
25 ani
Galati
cauta Barbat
26 - 55 ani |
|
|
Mrrrr's Forum (VIEW ONLY)InregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| pus acum 46 ore#1 |
TRaPModerator
Postari: 972
|
|
After you import the link https://www.cursbnr.ro/curs-valutar-mediu to PowerQuery, use Advanced Editor to replace the code with:
let
Source = Web.BrowserContents("https://www.cursbnr.ro/curs-valutar-mediu"),
HtmlSource = Source,
// Extract the year from Anul 2026
YearText = Text.BetweenDelimiters(
HtmlSource,
"<b>Anul ",
"</b>"
),
Year = Number.FromText(YearText),
// Extract the monthly exchange rate table
Data = Html.Table(
Source,
{
{"Month", "TABLE.table.table-md.table-striped.table-striped-custom.text-center > * > TR > :nth-child(1)"},
{"EUR", "TABLE.table.table-md.table-striped.table-striped-custom.text-center > * > TR > :nth-child(2)"}
},
[RowSelector="TABLE.table.table-md.table-striped.table-striped-custom.text-center > * > TR"]
),
// Remove header row
FilterHeaders = Table.SelectRows(
Data,
each [Month] <> "Luna"
),
// Add extracted year
AddYear = Table.AddColumn(
FilterHeaders,
"Year",
each Year,
Int64.Type
),
#"Changed Type with Locale" = Table.TransformColumnTypes(AddYear, {{"EUR", type number}}, "en-US")
in
#"Changed Type with Locale" |
|
|
| |
|
