but for the other two which are probably much larger datasets the data takes a very very long time to refresh. I'm not sure why but for 3 of the 5 queries the data refreshes pretty quickly. Period = Int64.From(Date.ToText(Date.From(DateTime.LocalNow()),"yyyyMM")) Period = Int64.From(Date.ToText(Date.AddMonths(Date.From(DateTime.LocalNow()),-1),"yyyyMM")) I've setup the queries and for the semi-automated part I tried to lookup a way to have the YYYYMM and YYYYMM-1 to update itself, I don't have a super strong background in vba, mainly taugh via google queries and I just started to try out mcode. I've also wanted to automate some of the process. I've tried to get more familiar with powerquery so I started to migrate these queries to retreive the data in powerquery then use PowerPivot to create a pivot table. At the beginning of each month I would update the period I was using in the format of YYYYMM so I would be saving one workbook as YYYYMM-1 (prior month) and one workbook as YYYYMM (current month) They would be pulled in as tables and once or twice a day I would right-click and refresh the data and save it with a date and time in the filename. I used to have workbooks with roughly 5 queries to a SQL database via the Microsoft Query Wizard. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified Only text posts are accepted you can have images in Text posts.Use the appropriate flair for non-questions.Post titles must be specific to your problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |