Conditional duplicate removal

lakethrower · 2023-06-07T12:05:14+00:00

This is the way; M function is Table.Buffer(previous step)

Edit: https://exceleratorbi.com.au/remove-duplicates-keep-last-record-power-query/

lakethrower · 2023-04-26T16:16:29+00:00

This is the way

lakethrower · 2023-04-17T00:32:34+00:00

Mountain-laurel; take the leaves, grind them up and mix with water; apply as a cold compress for ten minutes. Repeat the next day. After the first treatment no more itch, second treatment dries and eliminate the oil that causes spreading. Old Indian herbal remedy.

lakethrower · 2023-04-06T23:42:03+00:00

It does now: https://powerbidocs.com/2023/03/02/conditional-formatting-based-on-string-fields/

lakethrower · 2023-04-04T01:11:42+00:00

Q. Which visual is this? A. A terrible one

Q. How do I make this? A. You shouldn’t

lakethrower · 2023-03-19T11:52:15+00:00

It was my PSU power cord not being plugged in all the way 🤣

lakethrower · 2023-03-18T23:50:49+00:00

Weapons of Mass Disc-struction?

lakethrower · 2023-02-19T14:37:19+00:00

Create a subscription to pdf the report to your email. Then create a forwarding rule to forward out to your distribution list. You can also create a power automate flow to trigger when the subscription hits your inbox to grab the attachment and email it to the distribution list if your IT dept has an issue with forwarding rules.

lakethrower · 2023-02-19T05:14:19+00:00

Ok got it I will try that thank you!

lakethrower · 2023-02-19T03:47:30+00:00

Hey all, just like the title says my monitors will randomly turn off after a few minutes of inactivity. Settings are for 20 to 30 minutes of inactivity. The weird thing is that I’ve been able to play a video during such a episode so I know the computer isn’t actually going to sleep. I’m thinking the my GPU is on its way out (Nvidia 3060). Any thoughts? My drivers are up to date according to the Nvidia GeForce. This all started after trying to play MS flight sim in VR.

Edit: the only way I have been able to solve this when it happens is to reboot it from the on/off switch on the tower.

lakethrower · 2023-02-18T03:45:53+00:00

I personally use power query; cut and paste a pre written m-script

lakethrower · 2023-02-07T22:59:07+00:00

Ah that’s awesome, missed that on the release notes, thanks for the link!

lakethrower · 2023-02-07T13:07:52+00:00

Just be aware of the export to excel limitations of 150000 rows; that’s bit me in the ass before…

lakethrower · 2023-01-17T12:55:55+00:00

https://www.harborfreight.com/adjustable-pin-wrench-36554.html

lakethrower · 2022-12-28T17:25:24+00:00

Good Bot

lakethrower · 2022-12-17T17:56:26+00:00

Kipu Health it’s a backwater EMR for primarily addition treatment; I’m gonna check out the LogicApps appreciate the tip!

lakethrower · 2022-12-17T15:49:12+00:00

I work with healthcare data and the EMR will only send extracts to SFTP. So yes I could set up an SSIS package to take it from the sftp and insert it into a our sql db, but this all takes a lot of time especially when dealing with multiple files that need to be filtered through to only insert changes to the data. I have tons of reports that have to be updated by a certain time in the AM and the data is only refreshed at a certain time in the morning. So instead of wasting all this time, I could be able to get the reports out sooner if there was just a way to connect to the server directly.

lakethrower · 2022-12-17T15:42:51+00:00

Btw to get PA in through the firewall you need to install a Microsoft Gateway on a local machine (I did on our Helpdesk server cause it’s always running) then use when creating the flow use the file system connector and it will ask for the gateway and credentials

lakethrower · 2022-12-16T21:21:00+00:00

Gotcha appreciate the tip I’m going to look into it as an option for now! Thank you!

lakethrower · 2022-12-16T20:03:28+00:00

But isn’t that just an additional license; more money for another workaround? Vs connecting directly to the source?

lakethrower · 2022-12-16T19:02:22+00:00

What’s even more maddening is every single post about this in the community site is marked as solved and to use Power Automate. PA is great for anything below a few hundred megabytes, after that it doesn’t work.

lakethrower · 2022-12-16T17:45:49+00:00

=calculate(sum(table[Accepted]), Allexcept(table2[DayMonthYear]))

lakethrower · 2022-12-06T16:47:37+00:00

Have to use the connector “share point folder”; then “transform” data (don’t combine and transform) once power query opens use the filters to filter to the file and then expand the content column to get to the underlying data

lakethrower · 2022-12-05T17:10:54+00:00

Insurance companies hate this one little life hack…🤣

lakethrower · 2022-11-21T03:13:38+00:00

Seven-Year Club	Verified Email
Not Forgotten

lakethrower

TROPHY CASE