Forum

Adding custom colum...
 
Notifications
Clear all

Adding custom column in pivot table Trailing Twelve Months

2 Posts
2 Users
0 Reactions
221 Views
(@sward704)
Posts: 3
Active Member
Topic starter
 

Looking for help in getting custom column in a pivot table that can calculate Trailing 12 months  File attached  All numbers are fictional

 
Posted : 24/02/2023 7:19 am
(@catalinb)
Posts: 1937
Member Admin
 

Hi Shawn,

Is there a reason why you want the trailing 12 months in a column?

This is usually done as a measure, based on a calendar table:

https://community.powerbi.com/t5/Desktop/Trailing-12-months-DAX/td-p/1365606

 
Posted : 28/02/2023 7:28 am
Share: