topic Re: How to get values of yesterday with DAX Measure in DAX Commands and Tips

How to get values of yesterday with DAX Measure

PbiCeo — Sun, 17 Jan 2021 13:20:19 GMT

Hello everyone,

I want to get values of yesterday from the table below:

Date	Com	Amount
1/14	A	100
1/15	A	200
1/14	B	0
1/15	B	200
1/14	C	200
1/15	C	300
1/14	D	250
1/15	D	0

If today was 1/15 the values would be like below:
A: 100 B: 0 C: 200 D:250

To do that, I tried Measure and Caluculated Column below:
Column = TODAY()

Measure = CALCULATE(SUM('Sheet1'[Amount]), dateadd('Sheet1'[Column], -1, Day))

But nothing appeared on Table visual.

And also tried the below. but the output was the same as the original table data:

Column = TODAY() -1

Measure = CALCULATE(SUM('Sheet1'[Amount]), dateadd('Sheet1'[Column], 0, Day))

Any advice please?

Thanks,
Vladi

Re: How to get values of yesterday with DAX Measure

themistoklis — Sun, 17 Jan 2021 17:55:29 GMT

PbiCeo

Thy the following formula in a measure.

Measure = CALCULATE(MAX('Sheet1'[Amount]), dateadd(Sheet1[Date], -1, Day))

Then create a new table and add the field 'Com' and the 'Measure'

Re: How to get values of yesterday with DAX Measure

PbiCeo — Sun, 17 Jan 2021 22:58:54 GMT

themistoklis ,
Thank you for your advice.
Actually, it gets values of a previous day of the newest data.
I want to get values of yesterday. For example, I open PBIX on 1/15, values should be of 1/14.
How can I do with Today function?
Thank you,

Re: How to get values of yesterday with DAX Measure

mahoneypat — Mon, 18 Jan 2021 00:52:18 GMT

Please try this measure expression

Measure = CALCULATE(SUM('Sheet1'[Amount]), 'Sheet1'[Date] = TODAY() - 1)

Regards,

Pat

Re: How to get values of yesterday with DAX Measure

Anonymous — Mon, 18 Jan 2021 13:14:58 GMT

Hello PbiCeo ,
Please try this measure

Yesterday Values =

CALCULATE ( SUM ( Yesterday[Amount] ), DATEADD ( Yesterday[Date], -1, DAY ) )