Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi There, I have some sample data liks the below :
Year Revenue Type
2015 5758 Actual
2016 9854 Actual
2017 7557 Actual
2018 4983 Actual
2019 9435 Projected
I only want to select the revenue of the max year where type = 'Actual' i.e. 4983 of year 2018
How can I do this ? Apreciate your assistance and time.
Solved! Go to Solution.
Hi @Anonymous ,
Last Year Revenue = VAR _maxYear = CALCULATE ( MAX ( Rev[Year] ), FILTER ( ALL ( Rev ), Rev[Type] = "Actual" ) ) VAR _Revenue1 = CALCULATE ( MAX ( Rev[Revenue] ), FILTER ( Rev, MAX ( Rev[Year] ) = _maxYear ) ) RETURN _Revenue1
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Hi @Anonymous ,
Last Year Revenue = VAR _maxYear = CALCULATE ( MAX ( Rev[Year] ), FILTER ( ALL ( Rev ), Rev[Type] = "Actual" ) ) VAR _Revenue1 = CALCULATE ( MAX ( Rev[Revenue] ), FILTER ( Rev, MAX ( Rev[Year] ) = _maxYear ) ) RETURN _Revenue1
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |