Hi All,
I want to retrieve the data as table like below.
Customer Join Plan Month Balance
202301 202304
202302 202305
202303 202306
For Dimension :
Customer Join Plan Month
For expression:
SUM({$<Month ={' AddMonths($(vMaxMonthYear)-3)'}>}[Balance])
However this expression only can retrieve the latest month balance (202309 -3)of each Customer Join Plan Month like below table
Customer Join Plan Month Balance
202301 202306
202302 202306
202303 202306
Can anyone could help
