How to retrieve the latest Balance from the new join customer

eddywong71 — Tue, 03 Oct 2023 09:24:42 GMT

Hi All,

I want to retrieve the past 12 month new join customer with latest balance at line chart. For better understand , showed as below table.

I am using the expression in line chart like below.

Dimension:

= Date([Month], 'MMM YY')

Expression

SUM({$<[New Customer Indicator] = {1},
Month = {"$(='>' & Date(MonthStart(Max(Month),-12)) & '<=' & Date(Max(Month)))"}>}[Balance]).

However this Expression will retrieve the data like below table

Also i would like the user select the latest Balance Month For example: Month select (Apr2023)

topic How to retrieve the latest Balance from the new join customer in App Development