Forum Discussion
How to avoid weeks being cut short by the month?
Hello!
I would like to know if it is possible to avoid having duplicate weeks, by taking the data at a granularity level from month to week?
For example, in the graph it shows week 5 in both January and February, and it looks like sales fell in the last week of January, when they did not. The x-axis is Month and week
The dax I use is a calculation of sales for the current year:
Sales curr year = CALCULATE ([Sales], FILTER ( 'Calendar', 'Calendar'[Offset Year] = 0 ))
Hi Anonymous
Please try this:
I create a set of sample:
Then create a measure:
Measure = VAR _currentweek = MAX('Table (2)'[week]) RETURN CALCULATE( SUM('Table (2)'[value]), FILTER( ALLSELECTED('Table (2)'), 'Table (2)'[week] = _currentweek ) )The result is as follow:
Use the all(), allselected(), allexcept(), and removefilter() functions to remove unwanted filtering effects.
Here's a blog about contextual filteringUnderstand the Filter Context and How to Control i... - Microsoft Fabric Community
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous
Please try this:
I create a set of sample:
Then create a measure:
Measure = VAR _currentweek = MAX('Table (2)'[week]) RETURN CALCULATE( SUM('Table (2)'[value]), FILTER( ALLSELECTED('Table (2)'), 'Table (2)'[week] = _currentweek ) )The result is as follow:
Use the all(), allselected(), allexcept(), and removefilter() functions to remove unwanted filtering effects.
Here's a blog about contextual filteringUnderstand the Filter Context and How to Control i... - Microsoft Fabric Community
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.