Forum Discussion
Values previous Year to date
Hi All, I am currently looking at a TotalYTD and also looking at the same date period from the year before. Total Value YTD = TOTALYTD(Sum('Table 1'[Value]),'Table 1'[Full Date], 'Table 1'[Measure ...
Hi Griffy,
Are the date value in [Full Date] column continuos? Could you share some sample data?
Regards,
Jimmy Tao
Hi Jimmy,
Thanks, no the Full Date table is not continuous, this has been made up as in the data set that I have only had Month and Year, so when I import the data I create a new column called Full date which is 01+Month+year.
I won't be able to do a full date set but the data is like this below but just with a lot more in it.
| Full Date | Value | Measure Version |
| 01-Jan-18 | $2,248.95 | Actual |
| 01-Jan-18 | $225,267.49 | Actual |
| 01-Mar-18 | $3,017.19 | Actual |
| 01-Mar-18 | $2,988.20 | Actual |
| 01-Sep-18 | $1,438.50 | Actual |
| 01-Sep-18 | $1,776,906.64 | Actual |
| 01-Aug-17 | $701.00 | Last Year |
| 01-Jan-17 | $2,248.95 | Last Year |
| 01-Jan-17 | $225,267.49 | Last Year |
| 01-Mar-17 | $3,017.19 | Last Year |
| 01-Mar-17 | $2,988.20 | Last Year |
| 01-Sep-17 | $1,438.50 | Last Year |
| 01-Sep-17 | $1,776,906.64 | Last Year |
| 01-Aug-17 | $701.00 | Last Year |
Within the same Data set, i also have two orther measures Plan & RF.
I have tried to create a date table with the below code and tried this dax"
Total Value YTD Last Year = CALCULATE(SUM('BPC LBM'[Value]),PREVIOUSYEAR('Calendar'[Date]))"
Calendar =
VAR Days = CALENDAR ( DATE ( 2016, 1, 1 ), DATE ( 2018, 12, 31 ) )
RETURN ADDCOLUMNS (
Days,
"Year", YEAR ( [Date] ),
"Month Number", MONTH ( [Date] ),
"Month", FORMAT ( [Date], "mmmm" ),
"Year Month", FORMAT ( [Date], "mmm yy" )
)Thanks