Budget Cost different to orignal "2016 cost"


#1

Hi all
i have this budget issue ive been now trying to solve for hours and is now frustrating me i cannot solve. And i’m sure its really simple. but honesty its confusing!

To keep things simple. I wanted to budget my cost for year 2016 for occupation. So created another table using DAX. For now i’ve NOT added in any cost factor. I’ve just got cost for 2016. thats all. (see below)

issue:
So the issue is when i’ve crossed checked my numbers it show the cost coming from HR Budget table as being £104,885 more. Again just want to reiterate the cost from HR table i’m not adding in any % factor just yet. Just want to first reconile my numbers are correct for cost in 2016.

I’ve done checks so far like
-looking at blanks in Dates Tables
-Data Types are correct (no mis-match) this looks fine
-Ive used TREATAS.

I cannot upload this as pbxi file as its 3192KB.
Has anyone seen this issue before ? Because it sure my first time ive encoutered this.

Shrik


#2

Have you watched any of Sam’s video’s on Budgeting? I would suggest watching the May 2018 Learning Summit video on Budgeting Analysis to help point you in the right direction. If you can provide a PBIX file that may help answer your question as well. I saw where you said the file was to big. Is there any way to decrease the size of it to where the integrity of the data is not compromised?

Thanks
Jarrett

Enterprise%20DNA%20Expert%20-%20Small


#3

Hi Jarrett!
No problem. The reason why i cant reduce the data size within the Data Model is that it is linked to the SQL Adventure Works.

No worries it is nothing major - just bazzled at where the difference is coming from.

But thanks for getting back to me!
:slight_smile:


#4

The Math in the Budget looks to be spot on from looking at the data in the table from Jan-Mar, but make sure that you change the sort order for MonthInCalendar in your HR Budget Table.

Thanks
Jarrett

Enterprise%20DNA%20Expert%20-%20Small