Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 Version]="Actual")
This works fine and this gives me the Total year to date for the filter I require.
But the below does not seem to work;
Total Value YTD Last Year = CALCULATE(SUM('table 1'[Value]),PREVIOUSYEAR('table 1'[Full Date]))
I just get a blank value from this and I do not seem to get any data, this sum does not need to be filtered.
Also does this also only look at the same values say Jan – July? or will this calculate Jan – Dec?
Thanks
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"
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
96 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |