Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need the YTD totals for a reporting project with PowerPivot (not PowerBI). Whatever I try, the values are not adding, an I just get the original value...
TOTALYTD(SUM([AantalVanNaar-magazijneenheid); tblDatums(Datum)) and some variations
I have a dates table, linked to the other tables. Is there some issue here ?
thanks in advance
Didier
Solved! Go to Solution.
Hi Didier,
As we can see from your picture, you can't create a proper relationship with the columns that you already have. The relationship should base on the dates rather than the first day of the month. You can check it out in this file.
I think you need to make some changes of the formula to make it work as a calculated column. (I tested with TOTALMTD)
= CALCULATE ( TOTALMTD ( SUM ( [Value] ), 'RightTable'[Date] ), ALLEXCEPT ( 'RightTable', 'RightTable'[date] ) )
BTW, please go to here for professional help if you have questions about Excel. If this helps, please mark it as answer.
Best Regards,
Dale
Hi Didier,
As we can see from your picture, you can't create a proper relationship with the columns that you already have. The relationship should base on the dates rather than the first day of the month. You can check it out in this file.
I think you need to make some changes of the formula to make it work as a calculated column. (I tested with TOTALMTD)
= CALCULATE ( TOTALMTD ( SUM ( [Value] ), 'RightTable'[Date] ), ALLEXCEPT ( 'RightTable', 'RightTable'[date] ) )
BTW, please go to here for professional help if you have questions about Excel. If this helps, please mark it as answer.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |