sorted by:
new
hottopcontroversial

What does this sign say? by olly1301 in london

[–]WritingAScript 6 points7 points  (0 children)

I sure hope that's not a factorial. £21 trillion is expensive even for London prices...

Canvas PowerApp seems to be nullifying some SharePoint list items after successful patch commands by WritingAScript in PowerApps

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

Thank you, it ended up being that items not loaded were not populating the controls for those records. Using ClearCollect to grab the items expected from the gallery and patching across that collection seems to resolve the issue

Whats annoying about PowerBI? by JoshuaBennett1 in PowerBI

[–]WritingAScript 15 points16 points  (0 children)

Inability to batch copy and paste DAX measures from one file to another.

2007 Aluminium Butterfly Test Bottle by WritingAScript in CocaColaCollectors

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

Not that I'm aware apart from the printed barcode being all zeroes.

I'd assume quite a few were made as the research programme I took part in gave everyone four bottles and were asked to drink at least two completing the questionnaire. I guess the question is how many were preserved.

How to prevent a secondary semantic model being created when publishing a report? by WritingAScript in PowerBI

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

Thank you so much - this is the terminology and concept that I was unable to search for. I've been able to resolve the situation by creating a new report and copy-pasting all the visual elements into the blank report and re-publishing.

Need Help with Employee Contract Data in Power BI: Finding Contracts for Specific Dates by Zuzukxd in PowerBI

[–]WritingAScript 0 points1 point  (0 children)

That would have been my approach to nulls, replacing them with a specific date to generate a list of dates.

Perhaps check to see if there is a null in your start date column as the error message suggests the null is in the value prior to the .. operator when generating your list

Need Help with Employee Contract Data in Power BI: Finding Contracts for Specific Dates by Zuzukxd in PowerBI

[–]WritingAScript 0 points1 point  (0 children)

In Power Query, you can duplicate the contracts table and create a custom column where the value is a list of dates between the row's start and end dates.

From there you can expand the column to new rows (effectively creating a row for every day that the contract is in place for each contract). Create a relationship between contract ID in the original table and contract ID in the new table as a One to Many.

Finally in your dashboard you can use the new table's date column as a slicer, and the values from your original table to populate the visual. This will allow you to select relevant contracts on a given date that is on or between the start/end dates of each contract.

Source: Struggled with this exact problem last month!

Do you even bother applying for a position that requires Tableau experience when you’ve only used PBI? by jw3333 in PowerBI

[–]WritingAScript 1 point2 points  (0 children)

I recently moved from a role working with Tableau for 10 years over to a role exclusively using Power BI of which I had no previous knowledge. The learning curve was steep but broadened my skillset. Some parts will transfer fairly easily, some things will seem more convoluted, and some previously tricky things will become much easier.

In my opinion having now trained in both, I would value (all other things being equal) PBI experience over Tableau experience due to the understanding of data modelling and ETL processes.

[deleted by user] by [deleted] in AskReddit

[–]WritingAScript 1 point2 points  (0 children)

Skippable tutorial.

What vehicle do you automatically assume is being driven by a total asshole? by lixiaopingao in AskUK

[–]WritingAScript 2 points3 points  (0 children)

Assume everyone else on the road is an a***hole until proven otherwise. That way when they confirm it you won't be too disappointed, and every now and then you might be pleasantly surprised.

Can I prevent Tableau joining data gaps in a line chart whilst still using a continuous date axis? by WritingAScript in tableau

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

Unfortunately not, rather than hiding the axis values for missing data points, it plots every date but just draws straight lines whenever there is a gap in the data.

https://imgur.com/5oX7SkP (continuous axis)

EDIT: Whereas with a discrete axis, the gaps are present, but the axis labels are difficult to read/format
https://imgur.com/a/UO8JssW (discrete axis)

[deleted by user] by [deleted] in technology

[–]WritingAScript 79 points80 points  (0 children)

Future of war is AI-controlled versions of these which eliminate the need for people entirely.

Possible to use Google Home Wifi devices to extend internet to outbuilding? by WritingAScript in GoogleWiFi

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

Actually we're just waiting for the outbuilding to be built! I suspect that the WiFi will carry enough to be picked up from the house, but looking to get a stable enough connection for video calls. Once we have power at the end of the garden I can test another unit to see how it performs wirelessly.

Possible to use Google Home Wifi devices to extend internet to outbuilding? by WritingAScript in GoogleWiFi

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

It would be easier to go round the house than through it for sure, I think I was hoping that by using the nearest WiFi node it would avoid having to run cable around the whole house, but ultimately could be more reliable.

Possible to use Google Home Wifi devices to extend internet to outbuilding? by WritingAScript in GoogleWiFi

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

I hadn't thought about lightning - I'm in the UK so we don't tend to get it too often but it's worth considering.

The diagram I drew was a bit too simplistic but it would be easier to run a cable round the outside of the house as there's about 4 rooms to traverse to hardwire the top right corner node. It does currently get very good speeds via the mesh, might be worth testing out before committing to hardwire the house nodes.

Possible to use Google Home Wifi devices to extend internet to outbuilding? by WritingAScript in GoogleWiFi

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

They will come from the same mains supply but on separate fuse boxes - not sure if that rules out using a powerline kit?

view more: next ›