last Month value

[Anonymous]

Hi, 

I need Help,

How I can Get last mont total_balance ?

and

How I can Get yestarday total_balance ?

dependen on the table in image bellow , I did relation between Data tabel with Date column and DepDepositHistory Table with As_of_Date column

Regards,

[v-piga-msft]

Hi @Anonymous，

You could refer to the two measures below.

yesterday = CALCULATE(SUM(balance_[Balance]),PREVIOUSDAY('Date Table'[Date]))

last month = CALCULATE(SUM(balance_[Balance]),PREVIOUSMONTH('Date Table'[Date]))

And the output is below.

 

If you need additional help please share some data sample and expected output.

Best Regards,

Cherry

[Anonymous]

Hi, 

I need Help,

How I can Get last mont total_balance ?

and

How I can Get yestarday total_balance ?

dependen on the table in image bellow , I did relation between Data tabel with Date column and DepDepositHistory Table with As_of_Date column

Regards,