In the Data model, I created a simple calendar table - without linking it to the data table input. This data table is then loaded through PowerQuery to the Data model. The input data is just a data table, which her team updates, and then I added some formula logic to populate start/end dates of various steps in the process. Also, it allows to use various filters on the data presented. The reason for this approach was to make it more scalable without having to manually edit too many things. I opted for using a pivottable with conditional formatting, through PowerQuery -> Power Pivot. I recently helped out my wife a bit with a need for a Gantt Chart in Excel - she needed something to track her teams priorities - which should indicate priorities for other teams based on progress. 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. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |