Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
I need to accumulate a value from the beginning of the year until the date filtered by the user. But the beginning of the year is not always January, it may be April. In this case I have a table that shows how effective each year. Ex:
In the case when the user filters a period it should see the value of the beginning of the fiscal year until that filtered date.
This value has to be viewed by company, the measure below works for card objects, but not for charts with dimensions other than date. I believe that 'all' is doubling the values for all companies.
''Accumulate =
var maxfytd = CALCULATE(MAX(F0902[FYTD]))
var maxdate = CALCULATE(MAX(F0902[.Data]))
return
CALCULATE(SUM(F0902[Valor]);
FILTER(ALL(F0902);F0902[FYTD] = maxfytd && F0902[.Data] <= maxdate))'
Can someone help me?
Solved! Go to Solution.
Hi @Jacy,
Based on my test, you can refer to below steps:
1.I have entered some sample data like the picture below:
2.Create a measure.
Measure = CALCULATE(SUM(Sheet5[Value]),FILTER(ALL(Sheet5),'Sheet5'[Date]<=SELECTEDVALUE('Sheet5'[Date]) && YEAR(Sheet5[Date])=YEAR(SELECTEDVALUE(Sheet5[Date]))))
3.Create a Card visual and create a slicer, add the related field. Now you can see the result.
You can also download the PBIX file to have a view.
Regards,
Daniel He
Hi @Jacy,
could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @Jacy,
Based on my test, you can refer to below steps:
1.I have entered some sample data like the picture below:
2.Create a measure.
Measure = CALCULATE(SUM(Sheet5[Value]),FILTER(ALL(Sheet5),'Sheet5'[Date]<=SELECTEDVALUE('Sheet5'[Date]) && YEAR(Sheet5[Date])=YEAR(SELECTEDVALUE(Sheet5[Date]))))
3.Create a Card visual and create a slicer, add the related field. Now you can see the result.
You can also download the PBIX file to have a view.
Regards,
Daniel He
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
120 | |
74 | |
72 | |
58 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |