Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Power BI table doesn't sum up

Hi there,   I am quiet conserned about an issue i have in my report.   I am have built a model X where I want to calculate Budget YTD but unfortunately the table does not SUM UP correctly (Total)...
Need Help
v-xuding-msft's avatar
v-xuding-msft
Community Support
7 years ago

Hi Anonymous ,

I don't know what the formula of Budget YTD means. You could try to use the function of TOTALYTD to calculate.

 

Sales YTD = TOTALYTD(SUM('financials'[ Sales]), 'Table'[Date].[Date])

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Best Regards,

Xue

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.