Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am needing to create a formula for activity between two reload dates. I currently load a qvd weekly which gives me all data from a point in time (01/01/2018). As well as displaying statistics each week for that point in time I would also like to show the difference in numbers of the activity that occurred just between the two reload dates.
Example:
Chart:
week1 - Total discharges 120
week2 - Total discharges 160
//I would like to create a new chart showing the difference of '40' as a figure.
example formula I have tried but didn't work: ED_DatePulled=('>=$(=(max(ED_DatePulled)-7))<=$(=max(ED_DatePulled))'
Sum({<Date=,Month=,Week=,Year=,Quarter=>}[Discharges])-Above(Sum({<Date=,Month=,Week=,Year=,Quarter=>}[Discharges]))
Use week as dimension and enter all date related fields in red part to get correct result.
Can be this:
Sum({$<ED_DatePulled={">=$(=Date(Max(ED_DatePulled)-7))<=$(=Max(ED_DatePulled))"} >} Sales)
If you need only week wise differences then the case will be different, we need to fetch weeks from date in script and compare it with current and previous weeks i.e max week to last next week.
Thanks for responses. I ended up using a rangesum formula for my charts.
rangesum(count(episodes))-
rangesum(above(count(episodes)))