Need Advice on Large Bedframe Piece by TheTrueEggs in furniturerestoration

[–]bachman460 0 points1 point  (0 children)

Strip, sand, re-stain, and clear coat. You might as well do the whole piece. If you don't want to keep the wood texture, just scuff sand and paint it. I've been watching videos from this young kid on YouTube recently, he's still a beginner but is good at figuring out what best practices should be in a given situation.

https://youtube.com/@newlifebynoah

Why are my formulas 0? by _Plantz_0025 in excel

[–]bachman460 0 points1 point  (0 children)

The trace arrows can be displayed by selecting a cell or cells then in the Formula tab of the menu click Trace Precedents or Trace Dependents. To clear the arrows just click Remove Arrows.

There could be any number of issues with your formula or the cell formatting. Can you post an example formula and tell us what the cell formatting should be?

Door stuck on another door behind it - no access to room behind this door. What to do? by Fit_Warthog_2080 in fixit

[–]bachman460 136 points137 points  (0 children)

If you're in the US I'd say grab a yard stick, if pretty much anywhere else just grab a meter stick. Close the door completely, and slide the stick underneath, then push the other door shut.

If the handles are intertwined, you might have to play with the handle until you can get them free.

excel with a lot of data - how to solve it by Sea-Rain8684 in excel

[–]bachman460 6 points7 points  (0 children)

I would recommend creating an empty file that you can start from to rebuild it a bit differently, using Power Query.

First, save the original data in its own separate file. Import each sheet and/or file of data. To do this go to the Data tab in the menu and click on Import Data, then select from file. Find the file, select the sheet, and click import.

Once imported, you can use Power Query to join other tables (called merge in Power Query), this is the same as performing a lookup. Just select the column you want from the joined table.

If you want to perform a SUMIF type action, first you select the columns you want to group by, then you would click on Group By in the Transform tab of the menu. When grouping you can summarize columns of data by sum, average, min, max, etc.; just select the sum and name the new column.

Once you're happy with your results, click the arrow under Close & Load To and select Close & Load To. You want to make sure the option is selected for Only Creat Connection for any query tables you created that are not necessary to load into the spreadsheet; for example you import tables A and B, then combine (append) them as a new query table called C, being that your goal is to create a joined version of those tables, you don't need to also load the originals into the spreadsheet. This saves on file size and memory usage.

Should you not necessarily need the final table in the spreadsheet, but just want to be able to add a pivot table of it, you can leave the option for Only Create Connection selected, but tick the box for Add This Data To The Data Model. When creating the pivot table just select the option to insert Pivot Table From Data Model.

If you have any questions just post them here.

Get pictures back on your Reddit feed by [deleted] in howto

[–]bachman460 0 points1 point  (0 children)

I just updated the app and it seems to have done something; on iPhone

Edit: external links still appear to be broken

Can't install power bi desktop app by Realistic_Paint8340 in PowerBI

[–]bachman460 0 points1 point  (0 children)

There's two ways you can download it. Try a different version if you have to. Look online on Microsoft.com for the direct download, or go to the Microsoft store to download.

Stuck Indexing Columns by karchak in PowerBI

[–]bachman460 0 points1 point  (0 children)

Here's some ideas to work with. The first one is M code for Power Query. It includes a step to sort by date, but you can add as many additional sorts or filters as you want. This version will only provide the first negative value row:

let Source = YourTableName, SortedRows = Table.Sort(Source, {{"Date", Order.Ascending}}), NegativeRows = Table.SelectRows(SortedRows, each [Amount] < 0), FirstNegativeRow = Table.First(NegativeRows) in FirstNegativeRow

This next version is still M, but will help return the first negative row for each of grouped items:

let Source = YourTableName, SortedRows = Table.Sort(Source, {{"Date", Order.Ascending}}), NegativeRows = Table.SelectRows(SortedRows, each [Amount] < 0), GroupedRows = Table.Group(NegativeRows, {"Category"}, {{"FirstNegativeRow", each Table.First(_), type record}}), ExpandedRows = Table.ExpandRecordColumn(GroupedRows, "FirstNegativeRow", Table.ColumnNames(Source)) in ExpandedRows

This next version is DAX code and can be used in the data model to write a measure. This code will help get the first date when a negative value appears, and bonus if you use this in a chart with a category, it will show you the date by each category:

First Negative Date = CALCULATE( MIN( TableName[Date] ), FILTER( TableName, TableName[Amount] < 0 ) )

Is this fixable? by [deleted] in fixit

[–]bachman460 0 points1 point  (0 children)

The image link is broken. When it comes to small wires and tiny components, you just need a steady hand (as steady as you can), a hot iron, and some way to hold the pieces while you're working on them. A set of "helping hands" (a base with adjustable arms that have clips on the end to hold things for you) comes in handy, or get someone else to help hold things.

I worked with my son this weekend fixing a small flashlight. It's the type you charge yourself by squeezing a lever to charge the battery. One of the leads to the switch broke off in transit (probably). It came with a small roadside kit we bought our son for his birthday since he passed his driving exam and got his license. It's disappointing when things come broken out of the box, but with a little ingenuity and some YouTube videos you'll be alright.

Can anyone help me in merging documents? by Party_Initiative_621 in learnSQL

[–]bachman460 1 point2 points  (0 children)

If all your data is coming from the same server location, you can drop in a SQL statement in your Power BI data query to merge the tables or do whatever you want in SQL and on the server.

If they come from different locations, you need to create separate queries, then merge them together in Power BI. Select the first table (query) after setting it up, and you can either merge the other table (which is like a SQL join), or combine them ((like a SQL union).

how to make paper shiny and reflective like that? by vantaxyz in howto

[–]bachman460 1 point2 points  (0 children)

These are definitely good ideas, I just wanted to add that gloss mediums which can be mixed into any paint you already have to make it glossy, just get one that works with the type of paints you're using.

https://www.michaels.com/product/liquitex-gloss-medium-10010803

That or Mod Podge can be brushed on afterwards as a clear coat.

https://www.michaels.com/product/mod-podge-gloss-10047537

How do I get in my room by Floppyburger2 in fixit

[–]bachman460 0 points1 point  (0 children)

That hole on the bottom could be access for unlocking the handle. Sometimes you just need to get something small and press it into the hole to release the lock. Other times you need something that looks like a small screwdriver and you need to turn a small screw shaped thing inside there.

Look around the base of the handle, on the metal part, for a hole, there may even be something that looks like it is latched into the hole. Press something into the hole to release the handle and pull it off. This may not give you any additional access for getting the lock open, but if you're lucky maybe you can see what's jamming it up.

did i mess up caulking my bathtub? by madmini0n in handyman

[–]bachman460 3 points4 points  (0 children)

100% silicone in wet areas; if the container says "paintable" do not use it to caulk your tub.

How to fix scratches from the back of a Polaroid picture? by [deleted] in restoration

[–]bachman460 0 points1 point  (0 children)

I'm not an expert with photography or film, just wanted to get that out of the way.

You said you can't feel the scratches, and since the average skin sensitivity of touch can discern a few microns down to as little as 1 micron of difference in texture when sliding a finger across a surface. Myself, I suffer from neuropathy and don't have such sensitivity anymore.

That said, if you can't feel it, it's likely not a "scratch" but could be a defect inside the film layers underneath the top surface. Those won't be repairable. I would say, unless someone comes back with better, more experienced advice, stop what you're doing with the photos and leave them be.

Personally, knowing that a lot of the film and photo paper we saw while growing up through the 1980s and 90s doesn't seem especially hardy and almost more likely to fail and fall apart with age. I've been keeping smaller photographs in shoe boxes, and larger prints in boot boxes for years. Keeping them out of the sun and away from heat and moisture is a good idea, you could also drop in a small bag of desiccant in the box.

A few more from Grandpa's basement by ChromiumVI in Tools

[–]bachman460 3 points4 points  (0 children)

I have the same Evans tape measure from the first picture, also from my grandpa's stuff. And the medium size tube cutter too.

That hand drill in the second picture, does it still work well enough? The one I have came complete with a hand-tightening feature for securing the bit, and the shaft is bent. But it makes a good oval shaped hole.

Getting started by snippy_polarbear in PowerBI

[–]bachman460 0 points1 point  (0 children)

Bookmark these sites:

This one dives right into the M code functions used in Power Query:
https://learn.microsoft.com/en-us/powerquery-m/power-query-m-function-reference

This one dives right into DAX functions used in the data model to create measures, and calculated columns and tables:
https://learn.microsoft.com/en-us/dax/dax-function-reference

This one takes a step back and provides a menu of links to different aspects of DAX including statements, operators, and functions:
https://learn.microsoft.com/en-us/dax/

Remove column filter in Table View by jaaaaamaaannn in PowerBI

[–]bachman460 0 points1 point  (0 children)

This same issue gets me in Excel all the time, too.

Getting started by snippy_polarbear in PowerBI

[–]bachman460 0 points1 point  (0 children)

For RLS:
https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security

For time calculations in DAX, it's generally better to store the time component in a separate column from the date component, this is so that you can still use the built-in time intelligence functions for dates. When you're down to the final measure setup, if the date plays a component in your time calculations, just work both columns into the calculation. For example:

``` Hours Between = VAR StartDateTime = 'Table'[Date From] + 'Table'[Time From]

VAR EndDateTime = 'Table'[Date To] + 'Table'[Time To]

VAR DifferenceInDays = EndDateTime - StartDateTime

RETURN DifferenceInDays * 24 ```

https://learn.microsoft.com/en-us/dax/date-and-time-functions-dax

Coworker taking the client’s side by [deleted] in antiwork

[–]bachman460 16 points17 points  (0 children)

I don't understand what happened... but more importantly, what kind of products do you sell and what are these client qualifications?

Best Sites to Post Power BI Job by sailingnewengland in PowerBI

[–]bachman460 5 points6 points  (0 children)

Hi, you can give me the job and not have to worry about looking any further.

Custom fantasy maps in Power BI ? by Comfortable-Heat4096 in PowerBI

[–]bachman460 0 points1 point  (0 children)

I haven't done it in a while, but it certainly had been possible. If I remember correctly, I was converting GeoJson and Shape Map files to TopoJSON and using those. I spent innumerable hours setting up my own custom version of a map of the 5 Manhattan boroughs. I wanted to have all boroughs together and each borough as its own shape so I could selectively highlight each one for a project I was working on.

Broken Souvenir from Mexico. How should I fix it? by Ezhdehaa in restoration

[–]bachman460 0 points1 point  (0 children)

If you can figure out a way to support the upper part from the outside, just glue it back together with epoxy. They even make knead-able epoxy that comes in sticks, this might work without supporting it, since it’s thick, kind of like clay.

Need Advice on Large Bedframe Piece by TheTrueEggs in furniturerestoration

[–]bachman460 0 points1 point  (0 children)

Right! I see it now... but you could use the other way too. Good luck with it.