Week comparison

[Anonymous]

Hello All,
I have data which is updated on weekly basis for entire year . Once its updated i want to compare current week value with previous week value and display only the values which got reduced from previous week in Tabular form/(or any better method) till next week data updation.

My data shows like this 

For an example : Module 1 - Week 2 Process A to be compared with Week 1 process A and display if reduced .. same for Process 2 ...      goes on for every new week..

I tried for couple of days but couldnt get expected results. Should i do it in excel or is there a way to do it in Power Bi.
Thank you everyone..

[Anonymous · Accepted solution]

Hi~ @Anonymous 

Please create a new column.

Column = 
IF (
    'Table'[Value]
        < CALCULATE (
            SUM ( 'Table'[Value] ),
            'Table'[Week]
                = EARLIER ( 'Table'[Week] ) - 1,
            ALLEXCEPT ( 'Table', 'Table'[Module], 'Table'[Output] )
        ),
    'Table'[Value]
)

The result should be like this.

I hope I understand correctly, if not then please let me know.

Best Regards,

Community Support Team _ Gao

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Anonymous]

@Anonymous : Thank you so much.. Very helpful

[amitchandak]

@Anonymous , Create a separate week or week year table.

Create a column like this in week or year week column

Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

measures like these will help. with separate week table, it should work project wise
This Week = CALCULATE(sum('Table'[value]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[value]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))