Forum Discussion
Solved
Week over Week Variance - Waterfall Charts
Hi All, I'm trying to create a waterfall chart to spot changes week over week for forecast for particular customers. However I know I need to create a measure to find the variance but I need it for w...
grantlee - Yeah, what I would do would be to create a column in your data like this:
Column = VALUE(CONCATENATE(LEFT([WW],4),RIGHT([WW],2))
This should give you a column like 201750, 201801, etc. as numbers. There is probably a way that you could do this where you would get sequential numbers, which would be even more awesome.
Well, if that represents your source data, you can do this with a calculated column using EARLIER and the technique here:
See my article on Mean Time Before Failure (MTBF) which uses EARLIER: http://community.powerbi.com/t5/Community-Blog/Mean-Time-Between-Failure-MTBF-and-Power-BI/ba-p/339586
Now, that's a pretty nasty format for week though, you'll have to parse it with something like VALUE(RIGHT([WW]),2))