Amount 28 days ago with filter

[daliux]

Hello,

I need to count Amount 28 days ago. As you see, there is a feature (borrower_type). Hepl me, please

[ValtteriN]

Hi,

Here is one way to do this:

Value -28 =

var _date = 'Date 28 days ago'[Date-28] return

CALCULATE(SUM('Date 28 days ago'[Amount]),all('Date 28 days ago'),'Date 28 days ago'[Date]=_date)

Example:

I hope this helps to solve your issue and if it does consider accepting this as a solution and giving the post a thumbs up!

[daliux]

Thank you, 

It works, but not properly because it does not diffenciate amount between category (Borrower_Type). Do I need filter in this formula?

[ValtteriN]

Like Vahid points out just add a variable for the borrower type and you are good to go. I didn't notice you wanted to differentiate based on it also.

[VahidDM · Accepted solution]

Hi @daliux 

Try this:

Value -28 =

var _date = 'Date 28 days ago'[Date-28] 
Var _BT =  'Date 28 days ago'[Borrower_Type] 
return

CALCULATE(SUM('Date 28 days ago'[Amount]),filter(all('Date 28 days ago'),'Date 28 days ago'[Date]=_date&& 'Date 28 days ago'[Borrower_Type]=_BT ) )

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[daliux]

Thank you very much!!!!!