Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

December last year value

Hello! I have a fact table which has Sales values. I also have a date table and fact and date table are mapped. My question is, I have to calculate a month value for december last year.  Say if the ...
Need Help
OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
6 years ago

Hello PV

There are a various ways you could do this. Here is one that springs to mind:

Sales Previous December = 
CALCULATE ( 
    [Sales],
    PREVIOUSYEAR ( 'Date'[Date] ),
    'Date'[Month] = 12
)

Regards,

Owen