Any kind of help will be much appreciated .
Please find my solution attached.
Below is the steps
1st, join your data to a calendar table using key 1=1
2nd, Create calculation fields and built the view
Hope this helps
Book1 (43)_v10.2.twbx 42.0 KB
Thanks for your solution but i cant use this approach.I find some drawbacks in this approach -
1. Lets say there are 100 records in table and in calendar table we have 10 dates . Each row of calendar table join to all the rows to original table. Means it will be 10 * 100 = 1000 records in final data. Which will impact the performance.
2. We have to update calendar table. Lets say i have added 1 year data in calendar table but when year changes i will have to update calendar table. Its manual effort.