cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mohammed Member
Member

last Month value

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

 

test last.JPG

 

 

Regards,

2 REPLIES 2
mohammed Member
Member

last Month balance

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

 

test last.JPG

 

 

Regards,

Community Support Team
Community Support Team

Re: last Month value

Hi @mohammed

 

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.

 Capture.PNG

 

 

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

 

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.