Forum Discussion
Comparing budget data to actual data
Hey PBI Community, First time poster here - although I have been enjoying your forum as a reader previously. I'm trying to create a PBI visual that uses the clustered columns visual to displa...
yung_hoocher , If you have used
Sum(Table[Actual Amount]) , then it will not be cumulative
if you use
calculate(Sum(Table[Actual Amount]), datesytd('Date'[Date]))
it will be be cumulative
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Thank you for your guidance.
I don't think I am knowledgeable enough to properly test your solution.
Since I am a new user I cannot attach the file here.
Here's a link though: https://we.tl/t-5JmJoF5b5A
Thanks