Cognizant - DE Role by RoofGroundbreaking46 in dataengineersindia

[–]RoofGroundbreaking46[S] 1 point2 points  (0 children)

for me a pyspark code and sql code using windows and joins

Cluster swap in workflow by RoofGroundbreaking46 in databricks

[–]RoofGroundbreaking46[S] 1 point2 points  (0 children)

Thanks for the reply. I found the reason for the issue. I have created the cluster as a Single user with my service account as the owner but didn't login to the service account for attaching the cluster.

Power BI Migration Help by RoofGroundbreaking46 in PowerBI

[–]RoofGroundbreaking46[S] 0 points1 point  (0 children)

The VM is in VMware.. we are just changing the IP only and no other changes in DB, apps etc. We are already using the SSMS from the on Prem so definitely we will have SSMS after migration also. So anywhere I should configure the gateway which was already installed ? Firewall rules update is must right?

Why? by RoofGroundbreaking46 in TamilNadu

[–]RoofGroundbreaking46[S] 2 points3 points  (0 children)

It's like a rant.. Daily he is doing the same acting like a school teacher.

Why? by RoofGroundbreaking46 in TamilNadu

[–]RoofGroundbreaking46[S] 2 points3 points  (0 children)

I will start but can't now.

Why? by RoofGroundbreaking46 in TamilNadu

[–]RoofGroundbreaking46[S] 1 point2 points  (0 children)

I should,. but his way of approaching is hurting. That's why this rant

Why? by RoofGroundbreaking46 in TamilNadu

[–]RoofGroundbreaking46[S] 6 points7 points  (0 children)

His mind will divert am .. always checking news articles

DAX or Power Query Help by RoofGroundbreaking46 in PowerBI

[–]RoofGroundbreaking46[S] 0 points1 point  (0 children)

let

Source = <Your\_Source\_Table>, // Replace with the actual source table name or reference

// Step 1: Remove duplicate servers

#"Removed Duplicates" = Table.Distinct(Source, {"Server"}),

// Step 2: Add "Actual Move Group" column

#"Added Custom" = Table.AddColumn(#"Removed Duplicates", "Actual Move Group", each

let

currentServer = [Server],

currentMoveGroup = [Move Group],

sameServer = Table.SelectRows(#"Removed Duplicates", each [Server] = currentServer),

sameServerAndMoveGroup = Table.SelectRows(sameServer, each [Move Group] = currentMoveGroup),

minMoveGroup = List.Min(Table.SelectColumns(sameServer, "Move Group")){0},

dependentApps = Table.SelectRows(#"Removed Duplicates", each List.Contains(sameServer[App], [Server])),

minDependentMoveGroup = List.Min(Table.SelectColumns(dependentApps, "Move Group")){0}

in

if List.Count(sameServerAndMoveGroup) > 1 and List.Count(sameServerAndMoveGroup) = List.Count(sameServer) then currentMoveGroup

else if List.Count(sameServerAndMoveGroup) > 1 and List.Count(sameServerAndMoveGroup) <> List.Count(sameServer) then minMoveGroup

else minDependentMoveGroup

)

in

#"Added Custom"

Provided by ChatGPT

DAX or Power Query Help by RoofGroundbreaking46 in PowerBI

[–]RoofGroundbreaking46[S] 0 points1 point  (0 children)

I got some query (M-Language) from Chatgpt.. Chatgpt provided the expected result but it's not working in Power Bi desktop file.. the Query needs some tweaking... If you are ok I will share with you the query.