Forum Discussion

codyraptor's avatar
codyraptor
Resolver I
7 years ago
Solved

Deferred Revenue Model 12 months

I am struggeling on this one.  I'm trying to defer revenue for 12 months. Example: Sale Date = Jan 17 Revenue = 1200 Defer results: Jan = 100 Feb = 100 Mar = 100 etc.....   It should only de...
Need Help
  • codyraptor's avatar
    codyraptor
    7 years ago

    I figured it out I think.  These results are giving me what I expected.

     

    Table = GENERATE(
    'Orig Table',
    FILTER(
    CALENDAR(MIN('Orig Table'[Sales Date]),MAX('Orig Table'[Deferred Sales Date]))
    ,[Date]>=[Sales Date] && [Date] <= [Deferred Sales Date].[Date] && DAY([Date])=1))

    This gets the data to only look at the 1st day of the month in the calendar between the dates you've generated.  

codyraptor's avatar
codyraptor
Resolver I
7 years ago
codyraptor wrote:
Anonymous  

 

I see what it's doing now.  It's actually taking the Rev when I create the new table and applying it to each 'day' in the dates.  I only need my dates to reflect the month...so just 1/1/2017 for example.  I need the dates to reflect a single day and that would fix it.  Thoughts?

codyraptor's avatar
codyraptor
Resolver I
7 years ago

I figured it out I think.  These results are giving me what I expected.

 

Table = GENERATE(
'Orig Table',
FILTER(
CALENDAR(MIN('Orig Table'[Sales Date]),MAX('Orig Table'[Deferred Sales Date]))
,[Date]>=[Sales Date] && [Date] <= [Deferred Sales Date].[Date] && DAY([Date])=1))

This gets the data to only look at the 1st day of the month in the calendar between the dates you've generated.