May 23 2022 09:09 AM - edited Jun 04 2022 09:30 AM
Hello,
This is in need of help. I am not proficient in M language. I am trying.
I think there is a problem in this part.
-------------------------------------------------- -------------------------------------------------- -------------
I want to get a result like in the picture.
thanks
May 23 2022 09:33 AM
Hi @deniztopcu
Please re-share your files with i.e. with OneDrive, Google Drive... The links you provided are obviously not secured. Here is what I get after clicking on the Download button:
May 24 2022 04:30 AM - edited May 24 2022 05:18 AM
SolutionHi @deniztopcu
Assuming I understood the attached Power Query solution should do what you want
Notes:
- In the Query Options, Privacy Levels are ignored to avaoid a Firewall error that would not be easy to fix in your scenario (let me know if this is really an issue)
- It seems ARASE has no data before last quarter in 2021
May 24 2022 05:19 AM
May 24 2022 06:00 AM
May 24 2022 06:03 AM
May 24 2022 06:08 AM
You're welcome @deniztopcu
Re.
- Can we find a solution other than "ignoring Privacy Levels" - I don't know
See my previous reply
How dangerous can it be for me
If you only pulls the prices to your Excel sheet there's no risk
May 24 2022 06:14 AM
May 24 2022 06:17 AM
May 24 2022 04:30 AM - edited May 24 2022 05:18 AM
SolutionHi @deniztopcu
Assuming I understood the attached Power Query solution should do what you want
Notes:
- In the Query Options, Privacy Levels are ignored to avaoid a Firewall error that would not be easy to fix in your scenario (let me know if this is really an issue)
- It seems ARASE has no data before last quarter in 2021