Get data form previous day to calculate the difference

[WEARLE]

Oh hi

I currenly have a smart measure set that gets me data from 1/1/24 as below. I am rubbish at this so is there a way I can alter it so it just gets me the data from the previous day and calculates the difference for me? I have a day of the year column in the table if that needs to be used? 

difference from 01 January 2024 =

VAR __BASELINE_VALUE =

    CALCULATE(

        [Outstanding Task],

        'Daily Tasking Data'[Report Date] IN { DATE(2024, 1, 1) }

    )

VAR __MEASURE_VALUE = [Outstanding Task]

RETURN

    IF(NOT ISBLANK(__MEASURE_VALUE), __MEASURE_VALUE - __BASELINE_VALUE)

So need something that gives me this:

Day	Outstanding Tasks	Dif from prev day
1	23
2	654	631
3	123	-531
4	54	-69
5	321	267
6	321	0
7	32154	31833
8	245	-31909
9	125	-120
10	545	420
11	125	-420
12	1245	1120
13	654	-591

[amitchandak · Accepted solution]

@WEARLE , Assume you have measure [Outstanding Task]

Join date of you table with a date table and create measure

calculate([Outstanding Task], previousday(date[Date]) )

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[WEARLE]

Thanks @serpiva64 and @amitchandak that worked a treat 🙂

I have made a measure that subtracts 

Outstanding Task minus Dif from Previous day =

[Outstanding Task] - [Dif from Previous day]

How can I get it to ignore weekends? So that figure for 8/1 would use the data from 6/1 as the basline for the difference? I have a "Is Weekend" column in my date table which returns Yes No

Sorry and thanks for the help! 🙂

[serpiva64 · Accepted solution]

Hi,

you can use offset function.

create a measure

Diff using Offset =

var offsetout =CALCULATE(sum('Table'[Outstanding Tasks]), OFFSET(-1, ALLSELECTED('Table'[Day]), ORDERBY('Table'[Day], asc)))

var result = if (not ISBLANK(offsetOut), sum('Table'[Outstanding Tasks])-offsetout, BLANK())

RETURN

result

and obtain your result

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

[amitchandak · Accepted solution]

@WEARLE , Assume you have measure [Outstanding Task]

Join date of you table with a date table and create measure

calculate([Outstanding Task], previousday(date[Date]) )

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...