Forum Discussion

Litybe's avatar
Litybe
Regular Visitor
8 years ago

Display two graphics with two different date

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 ...
v-caliao-msft's avatar
v-caliao-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

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