Forum Discussion
Date Hierarchy problem when including weeks and months
I need to group data by weeks, months and quarters. I created a date table (marked as date table), turned off Auto Date / Time in options, and added the date, week ending and month ending to the sha...
Hi ttankka,
Do you means calculate result through data range which generate by two data columns? If this is a case, I'd like to suggest you create new table to store expand detail records and calculate on them
Reference link:
Spread revenue across period based on start and end date, slice and dase this using different dates
Regards,
Xiaoxin Sheng