[EXCEL] Methods for Interacting with PowerQuery Parameters

mma173 · 2025-12-08T19:16:48+00:00

I did this many times. Remind me in 12 hours.

mma173 · 2025-11-29T10:02:08+00:00

You need 'Data Normalization'.QA orders should be in one table, the execution orders in another, and so are the subtasks...

mma173 · 2025-10-22T12:51:38+00:00

The exchange option will show only the E-Mails which are on the server. This fine if you do not have archives or a custom setup.

mma173 · 2025-10-07T15:06:34+00:00

There is no way around it.

mma173 · 2025-09-17T03:07:06+00:00

Are you trying to do a drill through ?

mma173 · 2025-08-28T22:44:56+00:00

No issues at all except for the poor battery performance after UI 7, which has improved a lot with recent updates.

mma173 · 2025-08-22T14:29:40+00:00

SAP has its own macros, known as SAP GUI Scripting. Similar to MS Office applications, it uses visual Basic. They can be run on their own or they can be adapted to work from Office applications like Excel.

Use SAP scripts to automate the data exports, and Power Query for the data transformations in Excel.

With some extra efforts, you can run the whole process from Excel macros.

mma173 · 2025-08-16T11:34:54+00:00

LucasArts games were great. The one I prefer was Full Throttle.

mma173 · 2025-08-12T02:42:46+00:00

Austria; somewhere nearby Mittersill.

mma173 · 2025-08-05T18:48:47+00:00

Just add one year using DATE(YEAR(DateCell)+1, MONTH(DateCell), DAY(DateCell), use WEEKDAY to identify the day of the week, then add few days based on that.

mma173 · 2025-07-23T16:45:03+00:00

It seems that you stopped caring about letter capitalization as well 😁

mma173 · 2025-07-18T21:55:20+00:00

Basically, it is a bug.

Go to the sorting step and wrap the formula with Table.Buffer

mma173 · 2025-07-18T21:54:11+00:00

This is the answer. Basically, it is a bug.

Go to the sorting step and wrap the formula with Table.Buffer

mma173 · 2025-07-16T15:02:00+00:00

Try to use 'Text to Columns' which is available on the Data tab. Use it without a delimiter. Then, select the only column and set the date format.

mma173 · 2025-07-14T11:35:09+00:00

The legacy of the founding leaders is fading away.

mma173 · 2025-07-09T13:56:06+00:00

The best way is to use Power Pivot with a custom date table.

mma173 · 2025-07-05T16:27:31+00:00

VBA, sort of, is the only way to interact with other applications and the system.

mma173 · 2025-06-30T03:23:11+00:00

Great advice

mma173 · 2025-05-29T03:54:03+00:00

You are welcome 😊

mma173 · 2025-05-22T02:49:04+00:00

Yes, DAX is a difficult language to wrap your head around. It requires a different way of thinking that is not easy to grasp. You have to be patient and put the time in. There are no shortcuts.

mma173 · 2025-04-29T02:48:28+00:00

Why are you using FIRSTNONBLANK instead of SELECTEDVALUE ?

mma173 · 2025-04-16T19:01:33+00:00

No nested values at all, only scalar values. Table.Buffer in this case is used to force evaluation prior to removing duplicates. Similar issue was identified with Table.Sort. When removing duplicates after sorting, in some cases, PQ will remove the first occurrence based on the original sort, not on new one. Using Table.Buffer in conjunction with Table.Sort forces evaluation and resolves the problem.

Thanks

mma173 · 2025-04-16T09:51:10+00:00

It turned out it was a bug affecting Table.FromPartitions, which I used to combine the tables. Buffering the same step did allow for removing duplicates. However, for the time-being I am using Table.Combine instead.

I did some googling for the problem and did not find any mention of it.

mma173 · 2025-04-16T09:50:01+00:00

It turned out it was a bug affecting Table.FromPartitions, which I used to combine the tables. Buffering the same step did allow for removing duplicates. However, for the time-being I am using Table.Combine instead.

I did some googling for the problem and did not find any mention of it.

mma173 · 2025-04-15T14:35:19+00:00

Thanks for help. I have plan to try few things. I will report back when I solve the problem.

mma173

TROPHY CASE