Forum Discussion

mthomas1973's avatar
mthomas1973
Icon for Helper I rankHelper I
4 years ago

SAMPERIODLASTYEAR and visual filters

Good afternoon.    I have a requirement that shows a measure, and the same period last year in the same table. This is easy enough with the following:    CALCULATE([MEASURE], SAMEPERIODLASTYEAR('...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

mthomas1973 , The flag is in the date table? and relation with fact is single directional?

mthomas1973's avatar
mthomas1973
Icon for Helper I rankHelper I
4 years ago

Hi lamth , thank you for your reply. 

Yes, the flag is a simple 1 or 0 in the date table and it is has a single directional relationship with the fact table.