I'm trying to use it a bit, in order to automate some repetitive tasks with M-Language/PowerQuery in data files instead of using VBA/Macros; since it's easier to come to grips with than VBA. SigmaCoding on Youtube has cool tutorials on M-Language.Facewon wrote:Also, has anyone ever used power bi? Seems like a glorified pivot table and chart, but seems to have some advantages. File size and purdies for a start. Also, array, string and integer, probably in a coding context. What do they mean in regular human terms?
viceview51 wrote:I'm trying to use it a bit, in order to automate some repetitive tasks with M-Language/PowerQuery in data files instead of using VBA/Macros; since it's easier to come to grips with than VBA. SigmaCoding on Youtube has cool tutorials on M-Language.Facewon wrote:Also, has anyone ever used power bi? Seems like a glorified pivot table and chart, but seems to have some advantages. File size and purdies for a start. Also, array, string and integer, probably in a coding context. What do they mean in regular human terms?
But essentially it's a mix of PowerQuery, PowerPivot and PowerView - not that I ever used them since the company didn't allowed it until we migrated to office365 in the last couple of years and don't have in depth knowledge of them.
GooberTheHat wrote:365 combines the Web app and client version. The Web app doesn't have the full functionality but is fine for quick edits.
GooberTheHat wrote:365 combines the Web app and client version. The Web app doesn't have the full functionality but is fine for quick edits.
Subbax wrote:I find the webapp of Word an absolute shambles. If I design a doc in the app and then open it in the webapp, I swear it just reorders shit. Doesn't save them or anything but it just fucks up the view.
Facewon wrote:I am mostly studiously avoiding any fancy stuff with word.
Mail merge was fun enough.
Facewon wrote:ffs. Here's a random one. Have a spreadsheet getting form responses. Messing around with different ways to present the data. did my usual trick of simply making cells =cellonothersheet to then work with that data, but it's a live sheet, and when I add a new response, instead of populating under the last cell on the second sheet, it skips a row and shows nothing. Weird.
It looks like you're new here. If you want to get involved, click one of these buttons!