Display two graphics with two different date

[Litybe]

Hello,

I have a little question. I want to display two graphics, the first one with a date I choice ( for exemple 13/11/2016) and the second with the same data but 1 year before so 13/11/2015 in this case.

I have no trouble to display the first one, but i don't find a solution to display the second graphics with -1 year.

Have a nice day.

[v-caliao-msft]

@Litybe,

You could use SAMEPERIODLASTYEAR function to get last year data. This function returns a table that contains a column of dates shifted one year back in time from the dates in the specified dates column, in the current context.
https://msdn.microsoft.com/en-us/library/ee634972.aspx

Regards,

Charlie Liao

[Litybe]

Hello,

I have a little question. I want to display two graphics, the first one with a date I choice ( for exemple 13/11/2016) and the second with the same data but 1 year before so 13/11/2015 in this case.

I have no trouble to display the first one, but i don't find a solution to display the second graphics with -1 year.

Have a nice day.