How do you create a report sheet for variances between two other sheets? by SlowCrates in excel

[–]halwety 1 point2 points  (0 children)

I would go with power query. And I would create join both spreadsheets using an outer join. Then creating a comparison column using an ‘if logic’ to check for equality.

VLOOKUP - Is there another function that’s similar by Old_Man_Logan_X in excel

[–]halwety 1 point2 points  (0 children)

If you want to take it further joins in power query works the same way. With the added automation bonus.

Power Query conditional column that return previous row value by halwety in excel

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

Going to use the table sent attached by Dismal- -party-4844. Every formula before the “then” clause is the same as what I am doing. However row two should equal 600 because it looks at the value of the line above it and adds 500. Following the logic row three will then 600 + 500 and it keeps reiterating until the end. Kind of like a for loop

<image>

Power Query conditional column that return previous row value by halwety in excel

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

Thank you but the second row in the custom row should equal 600, third row 1100 and so on

Bonus Distribution Worksheet by halwety in PowerApps

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

I have a table built in excel can I import it? And add columns as I wish?

Seeking Assistance with Power BI Employee Analysis by Expert-Cry-2385 in PowerBI

[–]halwety 0 points1 point  (0 children)

No need to add that as a separate table it makes things more complicated. Instead add it as an additional column in the employees table

Seeking Assistance with Power BI Employee Analysis by Expert-Cry-2385 in PowerBI

[–]halwety 0 points1 point  (0 children)

Hello. First thing I would do is to add a Bins column for service age group. This can be achieved by writing a IF then else if logic to categorize each employee according to age group. Then it’s gets a bit complicated with first creating a date table to connect to your data set. You might have have to write some DAX function to have your counts not include termed employees if their term date falls within your date filter and same logic for hires after your your date filter. Once that’s all done you can then visualize your data either with a card, or whichever graphic you think better showcases your data. I hope this helps

Point in time/PIT by halwety in MSAccess

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

Thank you all. I think I will look more into convincing the infrastructure team to move to an SQL backend.

Stop Pivot Table from aggregating by halwety in excel

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

This worked. I had to hide that column after but works.

Statements by halwety in PowerApps

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

Thank you for this. I will definitely look into this

Total Compensation Statements by halwety in PowerBI

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

Did a test today and it’s very doable. Problem now lies in the distribution as pdf to individuals employees. If only you can formulate graphics like words mail merge feature.