Forum Discussion
YTD time intelligence wrong numbers-Odd behavior?
Hi bsas,
Thank you very much for your reply.
I've tried what you said and it works out. However I want the YTD to automatically detect the current year and compare with other years.
Basically I want to create a matrix in which I can compare YTD, LY and change between YTD and LY across different dates such as 2010,2011,2012,...2018.
Since I'm not a DAX jedi yet, I kind of lack the insight in DAX.
I've tried searching the forum and found many similar problems, however none of them which I could get to work:
/David
Post Patron
If you wanna detect current year then use Year(Today()) in your calculations. I'll look for a solution in the evening.
Thanks alot bsas I really appreciate your help.
Just a side note. It's pretty important for me to be able to specify a start date, since it's fiscal years I'm going to calculate, and it's not starting 1/1.
/DavidHi again.
Just an update.
I kinda of got the problem solved by using this code, where the .[Date] made the differenceYTD = TOTALYTD(SUM('Fact Orders'[OrderIntake_Lcy]);'Dim Calendar'[Date].[Date];ALL('Dim Calendar'[Date]);"4/30")Since I'm working with fiscal year I've specified "4/30" as my year end.
However I'm going to show YTD in a matrix with year as a column, but it only shows YTD values for the 2016 and not from may to may.
As illustrated below, the right YTD is the one seen in the bar chart for april (130.726). However in the matrix its 100.411. How can I show the correct YTD numbers in the matrix?
Thank you very much- bsas
You should look which date column are you using in matrix. Or you can try to add filer on your matrix view with start and end date for your fiscal year.
Hey bsas,
Thank you for your reply. No it does not solve the problemfiltering on date.
When I in the matrix select 2015 and 2016, it produces two columns with total value for 2015 and 2016, in stead of adding it up to fiscal year.