March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hello I'm new to dax syntaxe and I have an issue, I want to create a mesure that calculate the accumulated value between 2 years 2021 and 2022, that's mean in 2021 it get the normal budget value but in 2022 it get the sum of the budget for 2021 and 2022.
Hey @Aymen_Soussi ,
try the following approach:
Accumulated =
VAR vCurrentYear = YEAR( MAX( Abfrage1[date] ) )
RETURN
IF(
vCurrentYear = 2022,
CALCULATE(
SUM( Abfrage1[budget] ),
DATESINPERIOD(
'Date'[Date],
MAX( 'Date'[Date] ),
-1,
YEAR
)
),
SUM( Abfrage1[budget] )
)
Be aware that for that approach and for many that use time intelligence you need a date table:
Power Bi for Beginners: How to create a Date Table in Power Bi - Softcrylic
First of all thank you very much @selimovd for the quick response.
I just did some changes like (''Abfrage1'[date] in state of Date['Date']) I also changed SUM( Abfrage1[budget] ) by MAX( Abfrage1[budget] ) in the end of the query and the result is fine for the year 2021, but for the year 2022 it's not working like I want, may be I haven't clarify enough but the sum must be like this exemple : date :01/01/2021 budget :200, date :01/01/2022 budget :300, -> accumulated mesure for 2021 :200 which is ok by our work , accumulated mesure for 2022 : 500 !! so the sum must be like this: 01/01/2021 with 01/01/2022, then 01/02/2021 with 01/02/2022 ... by the acctual formula I think it calculate the sum of the hole year but what I want is to calculate the sum between the same dates ex: (01/01/2021 and 01/01/2022) but between the 2 years. I hope you get the idea @selimovd and thanks.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
25 | |
18 | |
15 | |
9 | |
8 |
User | Count |
---|---|
37 | |
32 | |
18 | |
16 | |
13 |