Forum Discussion
Trailing 12 Months?
Given this data:
How can I build a formula to calculate what the trailing 12 month average is for the NPS score? I'm not sure how to go about it since there are missing dates in this data. These ratings do not take place daily. Thanks!
1 Reply
v-piga-msftResident Rockstar
Hi Anonymous,
I suggest you could create a date table with CALENDAR function and create the relationship with the two tables.
Then you will get the complete date table.
If you need additonal help, please feel free to ask.
Best Regards,
Cherry