Forum Discussion
Sum coming up wrong
I'm not sure exactly what you're looking for, so two options below.
If you really want a measure with a fixed date filter, you can use this.
Fixed sum due date ?
CALCULATE (
SUM ( 'Item Table'[Net Amount] ),
ALL ( 'Calender Table'[Date] ),
'ITEM Table'[Expiration Date] <- DATE ( 2019, 1, 31 )
)If you want to use the values in the date segmentation, but in the Due date column instead, you can use this one.Add SlicerDates expiration date ?
CALCULATE (
SUM ( 'Item Table'[Net Amount] ),
ALL ( 'Calender Table'[Date] ),
TREATAS ( VALUES ( 'Calender Table'[Date] ), 'Item Table'[Expiration Date] )
)In either, if you do not want to remove the filter from the Date column of the calendar[Date], remove the ALL() part.If this works for you, mark it as the solution. Praise is also appreciated. Please let me know if you don't.
Best regards
Pat
azeemnazim
Not sure about what you are trying to calculate here. However, I hope you select dates up to 31/01/2020. but you have values for D after that particular date.
Please explain more clearly.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂
Hi,
The values in the visualization are not coming up correctly due to negative value i guess, Moreover, I have attached an excel file for data and my pbix file for a complete analysis
Thanks.
The issue due to negative value i guess , Moreover i have attached the pbix file and excel the values are not coming up correctly for item code A and D
azeemnazim
I checked the file but cannot understand your question. Please provide an example and explain how you are trying to calculate the value for the letter "D" for that amount. Can you show me the calculation logic?________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon if you like this reply 🙂