Forum Discussion
Deferred Revenue
Anonymous , with common date and account tables, you can use both measures together.
You need to use the period from date columns
- Anonymous4 years agoNot applicable
amitchandak Yes, that does work (see below), but is ultimately not what I am hoping to achieve.
My ideal scenario would be to have another Measure that has the logic built in from the Accounting Shipped Revenue measure, that still shows all of the months (not just the months that have a Revenue Date). In other words, something like an ALL function that still allows for all dates to be shown. Right now if I just were to use the Accounting Rev measure, it will only show values that have a Revenue Date. Ideally there would be logic that states "if deferred equals true" show the deferred value based on the revenue date, and if false, then show the shipped value (based on shipped date). This would have to be at the Order Line level, since an order can have multiple lines...some deferred, some not. As is the case below. Line one technically did ship in April, but because it was only received by the customer in May, the revenue was deferred until May.