The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Please help! I would like a measure that gets me the cumulative total year on year.
Thank you
Solved! Go to Solution.
Hi, @ronaldt5 ;
Base on my understand , you could create a measure .
Measure =
CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),[name]=MAX('Table'[name])&&[Date]<=MAX('Table'[Date])))
Or
percent% =
var _result=
DIVIDE(SUM('Table'[value]),
CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),[name]=MAX('Table'[name])&& YEAR([Date])=YEAR(MAX('Table'[Date]))-1)))-1
return IF(_result<>-1,_result)
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @ronaldt5 ;
Base on my understand , you could create a measure .
Measure =
CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),[name]=MAX('Table'[name])&&[Date]<=MAX('Table'[Date])))
Or
percent% =
var _result=
DIVIDE(SUM('Table'[value]),
CALCULATE(SUM('Table'[value]),FILTER(ALL('Table'),[name]=MAX('Table'[name])&& YEAR([Date])=YEAR(MAX('Table'[Date]))-1)))-1
return IF(_result<>-1,_result)
The final show:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@ronaldt5 Maybe:
Measure =
VAR __Year = MAX('Table'[Year])
VAR __Today = TODAY()
VAR __Date = DATE(__Year,MONTH(__Today),DAY(__Today))
VAR __Table = FILTER(ALLSELECTED('Table'),[Date]<=__Date)
RETURN
SUMX(__Table,[Value])
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
20 | |
19 | |
17 | |
13 |