Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Fiscal Date Calendar Calculations with Date Add

 Hello all!   Please pardon my questions as I am just beginning with DAX and haven't been able to really understand some solutions working through fiscal calendar that I've found.    I've loaded ...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

The functIon is working without error, however the numbers it is returning are not correct.

 

I checked the data set to ensure my date table was properly loaded and validated by splicing it by year, everything aggregates correctly. However, when I use the function with same period last year, the results are incorrect.

 

My company runs off of a 4-4-5 fiscal calendar, where the start of the year falls on 12/29/2017. I've loaded "calendar date" as the date to reference, however all other information in the date table is fiscal (fiscal_yr_nr, fiscal_mn_nr). It appears that using this function is maybe reading the calendar year potentially because even the totals for the year do not match.

 

Total Units LY = CALCULATE([Total Units],SAMEPERIODLASTYEAR('Date'[Date]))

 

Any help would be greatly appreciated, as I'm at a loss for how to correct this!

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/

 

I found this link and think I may have to do something similiar, I'm still not sure whether I would be able to do this with my current calendar. I don't have any import from our database date table in terms of which days have actualized so far as its using the fiscal day number in these calcs.