Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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) =
Solved! Go to 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()
)
)
)
@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()
)
)
)
User | Count |
---|---|
80 | |
74 | |
62 | |
61 | |
46 |
User | Count |
---|---|
108 | |
97 | |
88 | |
81 | |
61 |