Zach on 05 Aug 2017 02:06:41
Auto-calculation of differences (deltas) between columns in a matrix. For example, if you have a matrix that tracks outgoing products across multiple shipping dates, there should be an option that will auto-insert a column to display the delta for each day. It should refer not to the previous day (because what if there is a day that is skipped?) but rather the previous column entry.
Right now, it is very hard to do with a DAX expression, and the display will change or break once columns/filters are added.
Tableau has this feature already implemented...
http://onlinehelp.tableau.com/current/pro/desktop/en-us/calculations_tablecalculations_definebasic_difference.html
- Comments (2)
RE: differences
This would be extremely helpful for recons also. We used Tableau to do this.
Say we have prices for a ticker from 3 different data sources (on the same day). This could show the diff between the prices.
RE: differences
This fuction is really usefull, since we have to monitor everything based on previous performance,
such as:
are we growing? how many percent that we growth?
is our revenue is decreasing? how many percent are we decreasing?
even more usefull, if we can find out, what is increasing or decreasing more than x percent?
let's say we have a sales chart for many products, we want to find out:
what product is increasing more than 50% from last year or last month?
what product is decreasing more than 50% from last year or last month?