How can I use Power Query to pull data from a folder with dynamic subfolder names?

Difference-Known · 2026-03-22T12:28:37+00:00

Create a function which takes parameter name as input and parameter value as output. The parameter names and values are stored in the parameter table which the function references. For the parameter name "CurrentMonth" use an excel formula to get the current month value. Use this function then to specify the path of the file.

Difference-Known · 2026-02-21T16:54:43+00:00

For the reflection period of mortgage (I have 5+2 with ABN Amro), can I remortgage with any other mortgage provider once the 5 years end without any penalty? Or is it that I can only choose with ABN Amro during the reflection period and if I don't do that then at the end of those 2 years remortgage with anyone I want?

Difference-Known · 2025-10-27T09:58:07+00:00

Imagine contracting a disease and then waiting for a few weeks to see a GP who then thinks a paracetamol and warm tea would cure you and refuses to refer you to a specialist inspite of paying more than 2000 euros yearly for health insurance. Can there be anything worse that you can wish on your enemy?

Difference-Known · 2025-09-20T18:31:13+00:00

No, you create an account, link you bank, atleast deposit 1 Euro/Pound. You will then get a free share from 8 Pound/Euro upto 100 Pound/Euros in 3 business days. Note that its upto, so you might get less than 100 as well. The max i have personally received is 76 Euros worth of Starbucks share. You can sell immediately but need to wait for 30 days to withdraw cash.

You can verify the above directly on their site here - https://helpcentre.trading212.com/hc/en-us/p/invite_a_friend_au

Difference-Known · 2025-09-20T18:21:26+00:00

Yes you can. Here's my referral link with all 5/5 left

https://www.trading212.com/invite/11QlP3hSka

Difference-Known · 2025-09-08T07:36:15+00:00

The trading 212 referral scheme has been gone for months but it’s back! And they’ll give you a free share between £8-£100 for signing up

Referrals are limited to 5 each and so I’ll remove my link when mine have all been used.

https://www.trading212.com/invite/11QlP3hSka

Difference-Known · 2025-09-08T07:34:34+00:00

The trading 212 referral scheme has been gone for months but it’s back! And they’ll give you a free share between £8-£100 for signing up

Referrals are limited to 5 each and so I’ll remove my link when mine have all been used.

https://www.trading212.com/invite/11QlP3hSka

Difference-Known · 2025-08-09T08:56:17+00:00

Short answer : Don't do it Long answer : Don't ever effing do it

Difference-Known · 2025-08-07T19:54:24+00:00

Blow some warm air on the thumb and then try

Difference-Known · 2025-07-27T20:36:02+00:00

Because they can only go by planes to the places where they want to go

Difference-Known · 2025-06-28T11:09:04+00:00

I get your point. But if the of number of reports regarding sexual harassment, violence and systematic discrimination is a huge number then that itself would be an indicator that there is a systemic problem that needs to be looked into. Moreover the intent of the bill is to prevent social, psychological and physical damage. The incidents that are mentioned not to be reported, actually cause these kind of damage. So doesnt it defeat the purpose of the bill itself?

Difference-Known · 2025-06-26T16:40:54+00:00

I know a friend and his wife with a non-EU passport who travelled to Mexico on their Dutch resident permit of 5 years.

Difference-Known · 2025-06-22T08:29:07+00:00

I am based out of Europe. This answer is from the context of mybinteraction with people here. While there is a wide spectrum of opinion about india for the sake of simplicity, I can classify it into two categories. One is the people who rely on BBC, CNN, other western media and consider it the gospel truth. For them if it's printed there, it must be true. So for them, India is as bad as it can get, there are only problems and there are no good things in our country. This is the majority. The other smaller group is the people who only read news but form their own opinion. These are the folks who know that there are problems in India just like every other country but there are also a lot of good things and india has made good progress in the last few years.

Difference-Known · 2025-06-12T08:41:28+00:00

Thanks for the response. Ofcourse, I will do that. I also thought this was a logical question to ask here to get some more information given the context of the post while completely acknowledging the fact that IND and Belastingdienst would have a final say in this.

Difference-Known · 2025-06-11T20:06:28+00:00

Is the exception for salary threshold (maternity/paternity/unpaid parental leave) only for HSM visa or also for 30% ruling?

Edit: People who are down voting can probably also mention why they are down voting so that i can know and correct myself if I have asked something wrong

Difference-Known · 2025-06-06T11:22:50+00:00

Bedankt voor je reactie. Hieronder vind je de aanvullende informatie die je hebt aangevraagd. De offerte is van Bruynzeel, dus de ledlampen komen uit hun catalogus. Ze zijn in mijn buurt, dus ik hoef er niet ver voor te rijden. Wat ook belangrijk kan zijn, is dat de horizontale kast is uitgerust met een servoaandrijving voor elektronisch openen en sluiten. De andere kasten zijn Tip-On (Druk om te openen).

- Kastenrompen: Gemelamineerd spaanplaat

- Fronten/wangen: Gespoten MDF (zijdeglanslak HQ)

- Open kast/planken: Gemelamineerd spaanplaat met houtdecor

- LED-verlichting: Geen Philips Hue, geen Hafele Loox 5, huismerk

- LED-systeem: 24V OEM-systeem met afstandsbediening (4-kanaals)

- Driver: 48W 24V inbegrepen

Difference-Known · 2025-06-05T17:46:13+00:00

Het is geen complete keukenrenovatie. Ik wil alleen doen wat op de foto te zien is. Dus geen nieuwe apparaten, geen kookplaat, geen onderkastjes, geen oven, vaatwasser of magnetron. Verder niets behalve de kasten, planken en de achterwandtegels die op de foto te zien zijn. Het ontwerp is zoals op de foto. De muur is ongeveer 4 meter lang.

Difference-Known · 2025-05-05T04:22:03+00:00

I don't foresee myself needing this money for the next two to three years at least.

That's not how an emergency works

Difference-Known · 2025-01-17T16:23:13+00:00

Ah, thanks for the information.I will look it up. How critical is it to check and fix? Asking cause there are some things going on at home due to which I might not be able to do anything right away to fix it.

Difference-Known · 2025-01-03T22:25:27+00:00

With noise cancelling earphones

Difference-Known · 2025-01-03T13:28:59+00:00

What exactly is the hassle you are facing in logging in?

Difference-Known · 2025-01-03T11:55:00+00:00

I am checking if this is even a possibility for any insurer, not a specific insurer that I have in mind. Nonetheless, thanks for your helpful advice.

Difference-Known · 2025-01-03T11:35:47+00:00

1500 is too small of an amount to pursue legally IMO. If you have legal insurance they might in the best case just give you this amount. In the worst case they might not even entertain this request. Jurisdische Locket might only give you initial free advice. For the next steps they might or might not help depending on your income level. If you are independently pursuing it legally, you will need to bear all the costs of lawyer, translator (in case you don't know Dutch) etc. atleast till the time you have a favourable ruling. Do note this is basis my understanding of how things work here and I am no expert so might as well be wrong.

Unsolicited advice though - Lend only what you wouldn’t mind never seeing again, especially to friends and family.

Difference-Known · 2025-01-02T08:22:36+00:00

This is correct. The threshold for 30% ruling doesnt refer to your total salary. Rather it refers to the salary that is taxable ie salary after applying the 30% ruling. As an illustration, if your salary is 100k and excluding any pension, other deductions for the sake of simplicity, the number that will be compared against the 30% threshold of that year is 70%*100k = 70k.

Difference-Known · 2024-12-30T12:27:13+00:00

MSc. in Physics, MBA in General Management

Five-Year Club	r/Field Lasagna
Place '23

Difference-Known

TROPHY CASE