Forum Discussion

yung_hoocher's avatar
yung_hoocher
New Member
4 years ago

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...
Need Help
Tips and Tricks
Tutorial Requests
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

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.

yung_hoocher's avatar
yung_hoocher
New Member
4 years ago

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

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, yung_hoocher 

     

    I checked your sample file and didn't see the code for 'add 1000'. What does it mean? I don't know what data you want to change.

    If you can explain clearly, I think this problem will be solved well.

     

    Best Regards,
    Community Support Team _ Janey