Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
  • Anonymous's avatar
    Anonymous
    4 years ago

    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!

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

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))