Time intelligence on calendar connected via integer

[Pbiuserr]

Hello,

Is it possible to calculate for instance last year value when your calendar table is connected with fact tables with integers? 

If yes, then how?

[vanessafvg · Accepted solution]

do you have a proper date in your date calendar?   it doesn't matter if you  join on integers as long as you have a date data type in the table ie date rather than datekey to pass to the function, it should work fine as you pass that date to the date function, and it is is a date table with continious dates.