Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

New Customer Pattern Question - Modify to Consider Start Date Range Instead of Single Date

Hello everyone, I've beeing using an example from dax pattern to attempt to display a matrix where new customer revenue begins on the start date for each customer and ends after one year. The exam...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Greg_Deckler Thanks so much I'll give these a shot in the morning!

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Not certain what I've done wrong, but it just continues past one year. I'm sure it's something I've missed here's the full example.

    VAR tmpCalendar = ADDCOLUMNS('DIM Date',"DDate",DATEVALUE('DIM Date'[Date]))
VAR tmpBilling = ADDCOLUMNS('Sales',"StartDate",DATEVALUE(MIN('Sales'[Date])),
                                      "EndDate",DATEVALUE(MIN('Sales'[Date])+365))
VAR tmpTable = 
SELECTCOLUMNS(
    FILTER(
        GENERATE(
            tmpBilling,
            SUMMARIZE(tmpCalendar,[DDate])
        ),
        [DDate] >= [StartDate] &&
        [DDate] <= [EndDate]
    ),
    "Customer",'Sales'[Customer],
    "Date", [Date],
    "Amount", 'Sales'[Revenue]
)
RETURN SUMX(tmpTable,[Amount])