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.
Dear community,
I am trying to create a revenue trend chart by year and month but also I would like to show the total yearly revenue which will be the same for each month under the relevant year.
For instance: The "Sum Rev" has to be 49.340.623,90 for each month under 2017.
Total Revenue = SUM('Table'[Revenue])
Solved! Go to Solution.
Hi,
Thank you for sharing sample pbix file.
I assumed your sample had a calendar table.
Please check the attached file whether it suits your requirement, that I have changed the measure a little bit.
Sum Rev =
VAR _currentyear =
YEAR ( MAX ( Test[Reporting Month] ) )
RETURN
CALCULATE (
[Total Revenue],
FILTER ( ALL ( Test ), YEAR ( Test[Reporting Month] ) = _currentyear )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
I am not sure how your datamodel looks like, but please something like below whether it suits your requirement.
Sum Rev =
CALCULATE (
[Total Revenue],
ALL ( calenartable ),
VALUES ( calendartable[Year] )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
@Jihwan_Kim
Your query did not work for my data model.
Please reach my sample data through the below link:
SAMPLE LINK
Hi,
Thank you for sharing sample pbix file.
I assumed your sample had a calendar table.
Please check the attached file whether it suits your requirement, that I have changed the measure a little bit.
Sum Rev =
VAR _currentyear =
YEAR ( MAX ( Test[Reporting Month] ) )
RETURN
CALCULATE (
[Total Revenue],
FILTER ( ALL ( Test ), YEAR ( Test[Reporting Month] ) = _currentyear )
)
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
35 | |
32 | |
18 | |
18 |