Sameperiod Lastyear Issue

[Anonymous]

Hi everyone

I have some issue about function sameperiodlastyear,

I want to compare data between present year and last year value by using sameperiodlastyear, for whole data is ok, but when i filter select some product, i found my date data is not continue because "The relationship between date table and data table is both relationship " then the function is not calculated, so i try to solve with crossfilter function to "active single relationship" but it won't work.

Could anyone can suggest solution for this issue?

[amitchandak]

@Anonymous , Hope you are using a date filter. And that is 1-M single direction join. Not bi-directional join

Why Time Intelligence Fails - Power bi 5 Savior Steps for TI: https://youtu.be/OBf0rjpp5Hw