I also have a Date table which is NOT connected to the price table (as instructed in your other post). The line chart and matrix below it are the result of the following measure for "Last Price": My prices show as horizontal lines on the line chart, for each product only reading as the maximum price. I can't seem to get this to work as you describe in the other post you linked to. Hi for the huuge delay getting back to you. what would be the expression for this measure. Are you able to suggest the best way to plot this? I.e. if the price changed on Monday to £10, then on Friday the 'current' price is still £10. It feels like i need a measure(?) which calculates the 'Current' price for any given date, represented by the last price recorded for that product and variant prior to the date being plotted.Į.g. I guess i'm saying the 'current' price is the 'last price' recorded. I think this is where the initial suggestion could come in. there's no data for the date) the line will be horizontal. What i want to show is effectively a chart of the 'current' price on every day. What's missing there is that you can see in the chart that the 'A-Large' line stops short of the end, because it's where the data stops. Combining the two fields into a single calculated column makes a lot of sense. To be honest, I think it's a combination of the two that i need. I even tried pivots, but that doesn't look any better.Thanks and both really useful suggestions. This why I would love you sharing some useful tips or a better approach if you have any. Is there an easier solution to my problem? Perhaps. Even then, it gets fairly complicated when you work with a good amount of data. I've been playing with MATCH(), XLOOKUP(), SUMIF() and I must say that I'm running out of my creative juices. Productįrom this table we see that "A-2" is increasing by $10 in October, "B-1" is either discontinued or I simply didn't file the rate with the federal commission (oops), and that a new product "C-1" is introduced in October for this client as per my quotation. Below is a simplified example of a spreadsheet where unique identifiers are product and its category. By the time I work one contract I realize that there are probably a hundred new messages and another 149 contracts to work on. Unfortunately, this process is not automated and I am responsible for making these updates as well as keeping track of these changes as I said earlier. The problem is that I have numerous contracts with rate spreadsheets being as long as 10000 rows with 30 columns each where prices are constantly updated. Hello, I work for a sales department and every month I need to add, renew, remove the prices for different products and update our customers on any changes. 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |