Forum Discussion

KatkaS's avatar
KatkaS
Icon for Post Patron rankPost Patron
4 years ago

Comparing period, drill up in visual

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!
Need Help

2 Replies

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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