Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Issue with Custom Calculations and Filtering?

I am having issues with some of my calculations when I try to show it by region or store banner. I only have weekly data, so I have it by week start date, Week #, and Week Year. I have calculations f...
Need Help
MFelix's avatar
MFelix
Super User
7 years ago

Hi Anonymous ,

 

Do you have a Calendar table with a relationship to the Week Start of your sales?

 

I would create one calendar dimension table and make my calculations based on that table.

 

Can you share a little more information about your model maybe a mockup data setup?

 

Please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler).

 

Regards,

MFelix