Forum Discussion
Week comparison
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..
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!
3 Replies
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))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!
