Forum Discussion
Aggregating over date period
Hi all, how can I create a new table like example table 2, which contains aggregated time periods, from example table 1?
Anonymous add date dimension in your model with Quarter column in it, set relationship between date dimension and table 1, use Quarter column from date dimension and that will take care of it.
There are many posts that shows on how to add date dimension using DAX or Power Query.
1 Reply
- parry2k
Super User
Anonymous add date dimension in your model with Quarter column in it, set relationship between date dimension and table 1, use Quarter column from date dimension and that will take care of it.
There are many posts that shows on how to add date dimension using DAX or Power Query.