undefined

[ManjushVG]

Hi all, I am having matrix view in which I am having "Idea Title" column in Rows, "Month" from calculated date column is used in column and "Cumulative Total Planned Savings (USD)" in values as show in image below.

Cumulative Total Planned Savings (USD) =

VAR CurrentDate = TODAY()

VAR CurrentYear = YEAR(CurrentDate)

RETURN

    SUMX(

        'Initiative Tracker',

        CALCULATE(

            [Total Planned Savings (USD)],

            FILTER(

                ALL('Calendar Date'),

                YEAR('Calendar Date'[Date]) = CurrentYear

            )

        )

    )

Here [Total Planned Savings (USD)] is also a measure which is

[Total Planned Savings (USD)] = 

DIVIDE(SUM('Initiative Tracker'[Total Planned Savings (USD)]),SUM('Initiative Tracker'[Planned Saving Months]))

Let's go to above image, I am seeing the values 13490 for may. I have "Planned start date" column. Here 13490 is showing may beacuse the "Planned start date" has May date. My requirement is to show the same value 13490 for all the future months from May to december. This is for all the below rows as well. Based on the month of "Planned start date" I need to show the [Cumulative Total Planned Savings (USD)] to all future months of month in "Planned start date". Thanks in advance!

[amitchandak · Accepted solution]

@ManjushVG, Try like

Cumulative Total Planned Savings (USD) =
VAR CurrentDate = TODAY()
VAR CurrentYear = Max('Calendar Date'[Date])
RETURN
SUMX(
'Initiative Tracker',
CALCULATE(
[Total Planned Savings (USD)],
FILTER(
ALL('Calendar Date'),
YEAR('Calendar Date'[Date]) = CurrentYear
)
)
)

or you can try like

Cumulative Total Planned Savings (USD) =
VAR CurrentDate = TODAY()
VAR CurrentYear = Max('Calendar Date'[Date])
RETURN
SUMX(
'Initiative Tracker',
CALCULATE(
[Total Planned Savings (USD)],
FILTER(
ALL('Calendar Date'),
YEAR('Calendar Date'[Date]) = today()
)
)
)