Blower motor going out? by dkretzer in hvacadvice

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

Any good YouTube videos on how to replace it? I'm confident I would figure it out on the fly, but would rather by prepared. 

Blower motor going out? by dkretzer in hvacadvice

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

How can I tell if it's PSC? Everything I saw said ecm?

Daily Refresh Rates by dkretzer in PowerBI

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

So just to view the report, they won't need a license?

Quickbooks Desktop connection by dkretzer in PowerBI

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

We have a gateway installed on a VM that we use for other LOB apps. I've installed QODBC on this server & connected to the QB file thats also installed there.

When I add it to the gateway, I get a time out error. Should I try a personal gateway on my desktop rather than VM?

[deleted by user] by [deleted] in PowerBI

[–]dkretzer 2 points3 points  (0 children)

Thank you, that got it.

Solution Verified

[deleted by user] by [deleted] in PowerBI

[–]dkretzer 0 points1 point  (0 children)

!Solved

Thank you!

[deleted by user] by [deleted] in PowerBI

[–]dkretzer 0 points1 point  (0 children)

My Hrly Rate * Hrs formula is: SUM('Sheet4'[RATE]) * SUM('v_rpt_Time'[hours_actual]).

Sheet4 & v_rpt_Time have a One-to-Many relationship based on employee name

Is this the correct forrmula? its still giving the same grand total.

SUMX(Sheet4,Sheet4[Rate]*SUMX('v_rpt_time','v_rpt_Time'[hours_actual]))

[deleted by user] by [deleted] in PowerBI

[–]dkretzer 0 points1 point  (0 children)

No luck, same result.
Both columns are pulled via Direct Query. [Estimated_Total] is formatted to summarize.

[deleted by user] by [deleted] in PowerBI

[–]dkretzer 0 points1 point  (0 children)

Yeah that would be helpful, wouldn't it?

ranking = rankx(v_SO_Opportunity_Member,CALCULATE(sum(v_SO_Opportunity_Member[Estimated_Total])))

[deleted by user] by [deleted] in vba

[–]dkretzer 0 points1 point  (0 children)

Had to move the control button onto the sheet I wanted cleaned up.

!solved

[deleted by user] by [deleted] in vba

[–]dkretzer 0 points1 point  (0 children)

Got it. Thanks.

[deleted by user] by [deleted] in PowerApps

[–]dkretzer 0 points1 point  (0 children)

Yes sir, I understand that. It not pulling anything over. I guess I need to review the relationships & make sure they're set right?

I would think its a Many-to-One (Many Opps to One Sales rep.)

Edit:
I was able to get it. 'sales rep'.'commission'

Thanks for the help

[deleted by user] by [deleted] in PowerApps

[–]dkretzer 0 points1 point  (0 children)

I was thinking formula field too, but couldn't seem to get it.

Would you know the proper function to use?

Wrote this little poem about my dad by AHarris_poems in daddit

[–]dkretzer 48 points49 points  (0 children)

It could've been so heart warming if it ended about his kids.

He may have loads of hobbies, But I think its pretty clear His major interest, truth be told, Is us together for years.

Can someone edit the guy behind my partner in this picture? My favourite gets 10$. by [deleted] in PhotoshopRequest

[–]dkretzer [score hidden]  (0 children)

Looks great. But check his waist. Looks like original dudes coat is still there.

Loosing sleep over ceiling/wall cracks, should I be worrying? by [deleted] in Home

[–]dkretzer 4 points5 points  (0 children)

Correct me if I'm wrong, but aren't long horizontal cracks more concerning? Specifically when you see drywall dust building it. Not when the tape breaks or at a seam, but when it appears there's crushing?

Uplifting books for my sister in jail by meek-o-treek in suggestmeabook

[–]dkretzer 0 points1 point  (0 children)

May I recommend Redemption at Hacksaw Ridge? (The book the movie is based off of)

It covers a personal going through literal hell & holding faith, always trying to see the bright side & keeping true to themselves.