YTD and SAMEPERIODLASTYEAR problem (multiple fiscal year)

[EdouardPBI]

Hello everyone

i have a little problem with this case 

I have companies with different closing dates,

I have a calendar table that includes all the dates of each fiscal year by company,

my problem: I can't retrieve the YTD and the sameperiodlastyear

Does somebody have an idea ??

TotalYTD or Sameperiolastyear don't work

thanks a lot 🙂

the différent exercice 

calendar table per compagny (cle_date_ste = concat ( cod_ste & sales date) 

[Padycosmos]

You may create a calendar  table using calendaryearauto(fiscal year end month) and link it to your table(s)

https://learn.microsoft.com/en-us/dax/calendarauto-function-dax

This video might help:

https://www.youtube.com/watch?v=ef-KmCB-qXY

[EdouardPBI · Accepted solution]

unfortunately I already did , as you can see I already have a calendar table

the problem is that my exercise table has duplicate values ​​because I finally have a date for two companies, hence the concatenation of date + ste