Forum Discussion

ManjushVG's avatar
ManjushVG
New Member
2 years ago
Solved

undefined

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 ...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    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()
    )
    )
    )

     

amitchandak's avatar
amitchandak
Super User
2 years ago

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()
)
)
)