Forum Discussion

Fusilier's avatar
Fusilier
Icon for Helper III rankHelper III
3 years ago

Help with creating a custom column

Trying to get to grips with DAX creating a custom column. I want to create a custom column 'LY' that shows the value 12 months previously before the current date in mt 'Location Data' table. F...
FreemanZ's avatar
FreemanZ
Icon for Super User rankSuper User
3 years ago

hi Fusilier 

try to add a calculated column like:

LY =
MAXX(
    FILTER(
       data,      data[category]=EARLIER(data[category])&&data[subcategory]=EARLIER(data[subcategory])&&data[month]=EDATE(EARLIER(data[month]), -12)
    ),
    data[Value]
)