Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
User | Count |
---|---|
84 | |
80 | |
70 | |
47 | |
43 |
User | Count |
---|---|
109 | |
54 | |
50 | |
40 | |
40 |