Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
86 | |
82 | |
68 | |
64 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |