Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
TK_TG
New Member

Sameperiod Lastyear Issue

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?

1 REPLY 1
amitchandak
Super User
Super User

@TK_TG , 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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors