I've been trying for about 30 minutes to work out what on earth in my message the system is mistaking for code, and every time I press submit and it tells me vaguely "oh I think there's code in here, try again" I get more and more frustrated.
The current system is, honestly, dreadful. I'm a new user, asking a good faith question, and it's making me never want to use this website again. It could at least highlight where it thinks the issue is - I'm just being told night is day, again and again and again.
Why would Stack Overflow mistake prose for code? Alternatively, my message contains multiple tables, with one column containing values in the format "+3.2%" - does it think this is code?
Update: I've put all the tables in code tags after experimenting furiously, and it's posting now, so it was indeed the tables. I'm still not clear why it behaved this way, given the tables were showing up correctly in the preview, or which of the tables it had an issue with.
Basically - let's say I run a hat company, and every year the Hat Bureau gives us a guideline as to how much we can increase the price of hats. |Year|Price increase| |----|--------------| |2015|n/a first year| |2016|+3.2% | |2017|+2.2% | |2018|+4.0% | |2019|+1.0% | |2020|+0.0% | |2021|+4.0% | Where I've got so far with this, is I've worked out how to use product and filter to produce the following output... |Year|Price increase|Hat price| |----|--------------|---------| |2015|n/a first year|£3.00000 | |2016|+3.2% |£3.09600 | |2017|+2.2% |£3.16411 | |2018|+4.0% |£3.29068 | |2019|+1.0% |£3.32358 | |2020|+0.0% |£3.32358 | |2021|+4.0% |£3.45653 | ...But in the real world, I'm not applying an uplift of 2.2% to a £3.09600 hat and selling it for £3.16411, I'm actually calculating (£3.10 + 2.2%) -> £3.1682 -> £3.17 Which gives me a penny difference, and these penny differences accumulate over time. Does anyone have any suggestions for how I might build a "real world" calculation, where I'd round the price off every year and only apply the increase to the rounded price? Easy in Excel, but I can't work out a way to do it in Power BI without producing a new column for each consecutive year, which is impractical given the size of the (real, non-hat-related) data set. Ideally I'd want my data set to look like this... |Year|Hat price last year|Price increase|Hat price this year| |----|-------------------|--------------|-------------------| |2015|n/a |n/a |£3.00 | |2016|£3.00 |+3.2% |£3.10 | |2017|£3.10 |+2.2% |£3.17 | |2018|£3.17 |+4.0% |£3.30 | Happy with a DAX solution or a Power Query solution, I'd been trying to do something in DAX but I don't think I can direct a calculated column to itself.