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)
Go to 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
View solution in original post
You may create a calendar table using calendaryearauto(fiscal year end month) and link it to your table(s)
This video might help:
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.