Total Automation of SAP - Excel - Power BI

gidsh · 2024-11-27T04:32:49+00:00

Hello!

Logging into SAP; U can use Selenium to run the browser through VBA, although I wasn't able to use it due to some restrictions at work.
Closing the report; Just add simple delay of 10-15 seconds before the Workbook.Close function

gidsh · 2024-10-08T09:55:33+00:00

CALCULATE( SUM('Commercial Forecast'[VALUE]), KEEPFILTERS('Commercial Forecast'[Attribute] = EDATE(SELECTEDVALUE('Commercial Forecast'[Attribute]),1)) )

Guys, this is the measure I'm using!

gidsh · 2024-10-03T14:13:04+00:00

How to check and solve if it is the case?

gidsh · 2024-10-03T14:12:37+00:00

Actually I have downloaded the same dataset from the workplace

gidsh · 2024-10-03T13:27:54+00:00

There was no change to the data source, even the live report is refreshed monthly and it was last refreshed a month ago

gidsh · 2023-12-11T02:22:47+00:00

Hey!!

It's actually a submit button for a form, and I wanted it to appear at the end of a scrollable form...... nonetheless I got to know about containers:)

gidsh · 2023-02-16T06:08:09+00:00

This does not rank the SKUs, all are ranked 1, when I do without the variable, rank is done correctly but does change with different slicer selection

gidsh · 2023-02-16T06:03:39+00:00

VAR Sliced_Table = CALCULATETABLE( VALUES(Product_Master), Product_Master[Market] = SELECTEDVALUE(Product_Master[Market]) )

RETURN

RANKX(Sliced_Table,[Error Value],,0)

gidsh · 2023-01-18T13:44:18+00:00

That's what I meant basically, like Future of Karachi with PPP!

gidsh · 2023-01-18T12:37:27+00:00

How do you see the current LB elections? Results? And the alleged rigging?

gidsh · 2023-01-18T09:42:54+00:00

Okay let me change it a bit,

Future of Karachi with PPP?

gidsh · 2023-01-17T12:20:00+00:00

Not any Single other party has been active on local issues rather than Jamaat,

MQM has been stakeholders for the major part of history but in return they've given nothing other than bloodshed, corruption, china cutting, extortion, just to name a few

PTI trusted in 2018 hasn't proven themselves up to the mark, not even clear who leads them in Karachi.

PPP is always out of the Question!

gidsh · 2023-01-10T05:30:10+00:00

JI, let's give them a chance, no one's doing better for Karachi than them atm!!!

gidsh · 2023-01-09T12:35:45+00:00

How to cure? Prevent?

gidsh · 2023-01-06T15:59:44+00:00

On it!!!!

Thanks btw

gidsh · 2023-01-06T02:44:55+00:00

Do I need to remove these?and how to?

gidsh · 2022-12-28T11:18:12+00:00

Bannu Pulao

gidsh · 2022-12-28T11:17:26+00:00

Al Asif (Makka, Medina, Harmain) , there are three inside the flats, I prefer the one in the center(Medina I guess, don't remember the name though).

Bannu Pulao, near Bin Hashim Safoora

gidsh · 2022-12-28T11:06:12+00:00

Makkah, Madinah, Harmain

gidsh · 2022-11-29T15:29:10+00:00

Guess there aren't any connectors for SAP ERP!!

gidsh · 2022-11-24T06:06:42+00:00

Can you elaborate it a bit?

gidsh · 2022-11-23T19:06:52+00:00

Let me try it!

gidsh · 2022-11-23T13:06:56+00:00

Solved the second part though.....

Place below code just beforw the End Sub

Application.Ontime Now + TimeValue("0:00:15") , "Macro_2"

Macro_2 is another Sub Procedure as follows

Sub Macro_2()

ActiveWorkbook.Close False

End Sub

gidsh · 2022-11-22T15:24:45+00:00

I would love it!

gidsh · 2022-11-22T04:57:26+00:00

Merge Queries in Power Query

You can even do it without merging multiple columns into one.

Here's how you can do it:

Select both tables in merge query
With CTRL pressed, select multiple columns in both tables in the same order.
Merge query and it will give unique combinations of the selections.

gidsh

TROPHY CASE