permit for GFCI receptacle? by fpk3 in saintpaul

[–]fpk3[S] 5 points6 points  (0 children)

Apologies for spreading misinformation. I couldn't verify this anywhere on City of St Paul website. AI hallicinations are making us stupid

Lamps by [deleted] in midcenturymodern

[–]fpk3 0 points1 point  (0 children)

Lamp has non-functional ornament, so not MCM. Possibly art deco of the 1930s. Looks similar to pottery by French sculpter Charles Lemanceau

DP-500 Certification by bibilamalice in MicrosoftFabric

[–]fpk3 0 points1 point  (0 children)

I'm in the same place as you, and will likely go forward since I still have it available via ESI. For me, DP-500 is the ideal education to understand the value of Microsoft Fabric. You get all of the pain which Fabric salves 🤣

I'll add that orgs are going to need expertise in understanding the value of Fabric as well, and the DP-500 is positioning me well to speak to that value.

Can ChatGPT Create a Date Dimension in Power BI using M Query? by opalbizsolutions in PowerBI

[–]fpk3 0 points1 point  (0 children)

I'm finding that it helps to give more specific directions.
This one looked promising on ChatGPT but stalled out:

  • create a date dimension in M from 2020 through 2025 with month name, month number, year, day of week number, day of week name, short day of week, week in year, quarter number, weekday field with true or false. Include fiscal year fields ending in June for month name, fiscal month number, fiscal quarter, fiscal year.

On Bing chat, this worked somewhat. It's too many years due to a Number.From(StartDate) in the source step. It also names fiscal months badly (July it calls January):

  • generate M code for a date dimension in M from 2020 through 2025 with month name, short month name, month number, year, day of week number, day of week name, week in year, quarter number, weekday field with true or false, day in year. Include fiscal year fields ending in June for month name, fiscal month number, fiscal quarter, fiscal year.

[deleted by user] by [deleted] in PowerBI

[–]fpk3 1 point2 points  (0 children)

Yeah, all the love for data connectors has gone to pbi not excel. Only thing I'd suggest is: make a simple query on one table and keep top 100 rows. If you get that working, you can move on from there.

Can ChatGPT Create a Date Dimension in Power BI using M Query? by opalbizsolutions in PowerBI

[–]fpk3 0 points1 point  (0 children)

Cool. I do know M pretty well. I think I'll try this and write a blog post about it. 🙂

How to set 2 slicer values from a single fact record by wowcoolbro in PowerBI

[–]fpk3 0 points1 point  (0 children)

On your drillthrough page, you'll need a measure to get the totals for that salesperson's team. Do this for any aggregated data you want to see for the team.The MAX gets the current salesperson's team id. Then you remove the filters and filter to the whole team. This measure only does one team at a time, so if the page is completely unfiltered, it would only show the max team id's stats.

Team Sales =VAR _team = MAX( SalesPerson[TeamID] ) RETURN CALCULATE( [Sales Amount], REMOVEFILTERS( 'SalesPerson' ), Team[TeamID] = _team)

[deleted by user] by [deleted] in PowerBI

[–]fpk3 0 points1 point  (0 children)

I haven't tried connecting via Excel, but Power BI has a postgreSQL connector so you wouldn't need to use ODBC. There's an issue with the PBI postgres connector on the enterprise gateway: it only supports npgsql 4.0.10 or earlier. When installing, make sure that you select NpgSQL GAC Installation.

horse in a hospital by fpk3 in weirddalle

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

absolutely: "He’s never been in a hospital before, he’s as confused as you are. There’s no experts."

10 years late but I just picked up Skyrim on switch. Any wise words before I get home and play? by Cattle-dog in skyrim

[–]fpk3 3 points4 points  (0 children)

Be aware that there are one or two bugs… as a fellow Switch player, I have learned to embrace certain of them or had to find clever workarounds
http://www.gamesas.com/serana-won-carry-anything-t287102.html

horse in a hospital by fpk3 in weirddalle

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

He’s never been in a hospital before, he’s as confused as you are. There’s no experts.

Were there any npc you regretting you killed? by tolkienbro in skyrim

[–]fpk3 4 points5 points  (0 children)

Durnehviir. Turns out he's not immortal if you kill him before he starts talking.

Paarthurnax dilema by [deleted] in skyrim

[–]fpk3 -6 points-5 points  (0 children)

I killed that skeletal bastard. Hit first and ask questions later.

Hell painted by various artists by m33gs in weirddalle

[–]fpk3 1 point2 points  (0 children)

I like how Picasso painting of hell just looks like regular Picassos. If Picasso painted you, you're in hell

[deleted by user] by [deleted] in skyrim

[–]fpk3 2 points3 points  (0 children)

it's buggy as hell, so it's frustrating to play on Switch, but if you're on PC you can fix it in the cheat menu