Forum Discussion
Post ProdigyTime intelligence on calendar connected via integer
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?
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.
1 Reply
- vanessafvg
Community Champion
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.