Comparing period, drill up in visual

[KatkaS]

Hello

I have a measure that is comparing data of the previous week with the current one, please see below.

The measure is working fine, but if I want to Drill up to see monthly data (I use Clustered column chart), I get wrong numbers.

I assumed that the monthly numbers would be summed up, but that is a wrong logic, right..?

And If I create new measure (same as below, but I replace week with month), the result is summing up all data, not comparing month by month..

To complete the information, I receive new file every week with updated data.

Change of status to CLOSED WEEK =

VAR __thisWeekCount = COUNTROWS(FILTER(ALL('Ann-Sofie Recruitments'),'Ann-Sofie Recruitments'[PERIOD]=MAX('Ann-Sofie Recruitments'[PERIOD]) && 'Ann-Sofie Recruitments'[Status - Copy]="2.8 Closed"))

VAR __lastWeekCount = COUNTROWS(FILTER(ALL('Ann-Sofie Recruitments'),'Ann-Sofie Recruitments'[PERIOD]=MAX('Ann-Sofie Recruitments'[PERIOD])-7 && 'Ann-Sofie Recruitments'[Status - Copy]="2.8 Closed"))

RETURN

__thisWeekCount - __lastWeekCount

Could someone have a look into this please..?

Thank you!

[v-luwang-msft]

Hi @KatkaS ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @KatkaS ,

In my tests, your MEASURE is fine, see below. If there is a problem using in your data, is it possible to provide the template data with the problem and the expected output. Remember to remove confidential data.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien