Measure to show difference in attribute from past date to current

[Rotrox404]

Hello,  

I have a dataset that lists out the value of 'Completed Work' on each day of the week for 'Work Item ID'.   I want to create a visualization that shows the difference in 'Completed Work' from the current date and 'Sunday' of the current week for each unique 'Work Item ID'.    I currently have the dataset filtered to show only one week's worth of Work Items, but ideally, I would be able to expand this to a monthly view and get a read out of work done on each item on a weekly basis for the whole month.  

Thanks in advance,

R.

[Zubair_Muhammad · Accepted solution]

Hi @Rotrox404

Please try this MEASURE

Difference from Sunday =
VAR CompletedWorkonSunday =
    CALCULATE (
        SUM ( Table1[Completed Work] ),
        FILTER (
            ALLEXCEPT ( Table1, Table1[Work Item Id] ),
            WEEKNUM ( Table1[Date] ) = WEEKNUM ( SELECTEDVALUE ( Table1[Date] ) )
                && WEEKDAY ( Table1[Date], 1 ) = 1
        )
    )
RETURN
    SUM ( Table1[Completed Work] ) - CompletedWorkonSunday

[Rotrox404]

Thanks, was able to use this to guide me towards the solution I needed!