Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Dear all,
I have a reporting with realised 2021/ budget 2022/YTD 2022 by month, how can i add budget 2023?
the report is fix on year 2021, all the data of 2022 was done by mesure with nextyear
Solved! Go to Solution.
@Orange2045 , add one more year
Change table name if needed
Cout Total B23 = CALCULATE(SUM('Budget 2022'[Coûts B22]),nextyear(dateadd('0_Date'[Date],1,Year) ))
Make sure calendar has dates till 2023
Thank you😀
@Orange2045 , add one more year
Change table name if needed
Cout Total B23 = CALCULATE(SUM('Budget 2022'[Coûts B22]),nextyear(dateadd('0_Date'[Date],1,Year) ))
Make sure calendar has dates till 2023
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
67 | |
61 | |
52 | |
36 | |
35 |
User | Count |
---|---|
84 | |
74 | |
56 | |
45 | |
44 |