Forum Discussion

2016Cayenne's avatar
2016Cayenne
Frequent Visitor
2 years ago
Solved

Custom Column - previous year value

Hi, I've tried many different 'earlier' solutions I've found on this forum but can't get them to work for my data. I have a table of customer totals per product per year.  I want to create a custom...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    2 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

    It is for creating a calculated column.

     

     

     

    Previous year total CC =
VAR _prevyear =
    DATE ( YEAR ( data[reportingdate] ) - 1, MONTH ( data[reportingdate] ), DAY ( data[reportingdate] ) )
RETURN
    SUMX (
        FILTER (
            data,
            data[customer] = EARLIER ( data[customer] )
                && data[product] = EARLIER ( data[product] )
                && data[reportingdate] = _prevyear
        ),
        data[total]
    )
2016Cayenne's avatar
2016Cayenne
Frequent Visitor
2 years ago

Thanks Jihwan_Kim !  that worked and I see what I was going wrong.