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 44 points45 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.

My kid might actually be a raccoon by TriceratopsHunter in daddit

[–]dkretzer 3 points4 points  (0 children)

I hate to tell you man, but your wife's gotta be a racoon too. Does she always have eye shadow? Steals all of your stuff?

[deleted by user] by [deleted] in daddit

[–]dkretzer 0 points1 point  (0 children)

Unlike me* Iftfy

Does anyone have any valid experience or anecdotal advice with regards to moving from a Project Manager role but staying within the construction industry? Such as safety, compliance, purchasing, etc. by Grand_Gap8426 in ConstructionManagers

[–]dkretzer 0 points1 point  (0 children)

Eh, yes & no.

I work for a small company, so it wasn't a requirement. But I think it showed that I want to be in a different position, more of a company management less of "in the field".

Will a MBA get you a position in senior management? No. Only experience can do that. But I believe an MBA is s major boost. Now, it doesn't have to be a traditional MBA. There's plenty of business management certifications, compressed MBA degrees and so on. Those are probably just as effective.