Hi experts,
I would like to create a new column with last 1 year values, where A is the last value and A need to be the first value, as is possible to see below.
| Cliente | Type | Value | Date | | Dream |
| 1 | A | 50 | 4/30/2016 | | |
| 1 | B | 34 | 4/30/2016 | | |
| 1 | B | 50 | 4/30/2016 | | |
| 1 | B | 500 | 9/30/2017 | | |
| 1 | C | 110 | 9/30/2017 | | |
| 1 | C | 100 | 9/30/2017 | | |
| 1 | C | 10 | 10/24/2017 | | |
| 1 | A | 50 | 10/24/2017 | | TRUE |
| 1 | A | 40 | 12/21/2017 | | TRUE |
| 1 | B | 50 | 12/18/2017 | | TRUE |
| 1 | B | 45 | 1/19/2018 | | TRUE |
| 1 | A | 5 | 3/27/2018 | | TRUE |
| 2 | A | 500 | 4/30/2016 | | |
| 2 | B | 600 | 9/30/2017 | | |
| 2 | A | 30 | 9/27/2017 | | TRUE |
| 2 | B | 50 | 10/24/2017 | | TRUE |
| 2 | C | 34 | 12/21/2017 | | TRUE |
| 2 | C | 56 | 12/18/2017 | | TRUE |
| 2 | A | 86 | 1/19/2018 | | TRUE |
| 2 | B | 66 | 3/22/2018 | | |
I tryied to use this formula, but I didnt have sucess.
Period_1year =
VAR CurrentDate =
CALCULATE(MAX ( Table[Date]),ALLEXCEPT(Table,Table[Client]))
VAR StartingPoint =
CALCULATE( EOMONTH( CurrentDate, -12 ) + 1, Table[Type] = "A" )
RETURN
Table[Date]>=StartingPoint && Table[Date.1]<=CurrentDate
Best Regards
Juli
