HNHacker News
TopNewBestAskShowJobs

kvna

18 karma · joined June 13, 2019

submissionscomments
kvna··on Benzene detected in many sunscreen products
It’s presumably not the talc but the asbestos found in the talc deposits that makes its way into the baby powder
kvna··on XLOOKUP for Excel
If you add your table to the data model you can do count distinct with a pivot table
kvna··on Robinhood raises $323M at a $7.6B valuation
The only issue I have had with Robinhood is regarding tax planning, because they only support FIFO sell orders. There have been several instances where I would have preferred to sell shares purchased more recently, so that my older shares can pass the one year threshold for long term capital gains. The ability to specify lots when selling shares would be worth money to me.
kvna··on The New York Times course to teach its reporters data skills is now open-source
The best way to create reusable formulas in your workbooks is to add your table to the data model (which creates an in-memory tabular cube) and write measures using the DAX formula language. This has the added benefit that a single formula can be written to aggregate data at different levels, for example, a sum can be calculated over days, months, or years. This will only allow you to share formulas in a single workbook. The data model in Excel is powerful and under utilized.