cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pradeep467 Frequent Visitor
Frequent Visitor

Creating QTD and YTD metrics on a weekly aggregate table

Hi All,

I am solving a business requirement and stuck with the below issue.So  here is my specific requirement, where I have a fact table whose grain is like Store,Week,Department and Sales. I need to build  QTD and YTD measures for Sales based on the week Fact table.  Based on my primary research I can create these measures if I have a date table and the Fact at a day level, but in my case as the fact table is at a week level, is it possible to the achieve the same or if there is any work around. Please suggest.

 

Pradeep

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Creating QTD and YTD metrics on a weekly aggregate table

@pradeep467,

 

For any time intelligence function, you could implement a custom DAX formula.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: Creating QTD and YTD metrics on a weekly aggregate table

@pradeep467,

 

For any time intelligence function, you could implement a custom DAX formula.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
pradeep467 Frequent Visitor
Frequent Visitor

Re: Creating QTD and YTD metrics on a weekly aggregate table

Thanks for the response and apologies for the delayed feedback, I went through those blogs but all of them are pretty much have a table at a day level, in my scenario I have my fact at a week level having a week surrogate key (Eg:201834 --Week 34 2018) joined on week surrogate key from week dimension. I have a week start date and week end date, in this case hoiw can I develop the qtd measure?