Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |