topic Date one year back same month period in DAX Commands and Tips

Date one year back same month period

Anonymous — Wed, 30 Mar 2022 14:10:19 GMT

Hi!

I'm looking for an calculation function. I wan't to calculate an metric (NPS) over an certain period of time. The metric is already working as supposed. But based on the date field i want to calculate this metric over this month an year ago. So for today i want to calculate the NPS over March - 2021.

Is this possible with time intelligence?

Re: Date one year back same month period

tamerj1 — Wed, 30 Mar 2022 14:30:00 GMT

Anonymous

yes possible. Please share sample data and some details

Re: Date one year back same month period

Icey — Mon, 04 Apr 2022 07:59:29 GMT

Hi Anonymous ,

Please try to use SAMEPERIODLASTYEAR function. It 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.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.