SAMEPERIODLASTYEAR() function

[masry]

Ex : I have number of passengers of the current month 5/2017 and I need to get the number of passengers for the same month of the last year 5/2016 , so I used the DAX function (SAMEPERIODLASTYEAR) but it didn’t work with me as this fun just work with dates on the level days not on the minutes or seconds level .

Our date example in our data : ‘2015-01-01 00:04:00’ , ‘2015-01-01 00:05:00’ , ....

any help ?

[v-caliao-msft]

@masry,

this fun just work with dates on the level days not on the minutes or seconds level

If this is the case, so you could duplicate this column and change this column's data type from date/time to date.

Regards,

Charlie Liao

[vanessafvg]

have you got a date table?  always best practice to use a date table working off a date type data type rather than date time i would think.