How to get values of yesterday with DAX Measure

[PbiCeo]

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

[Anonymous]

Hello @PbiCeo ,
Please try this measure

Yesterday Values =

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

[mahoneypat]

Please try this measure expression

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

Regards,

Pat

[themistoklis]

@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'

[PbiCeo]

@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,