OMB Public Budget Database – Budget Authority and offsetting receipts 1976-Current

For a tutorial video that walks you through the process of using the Open Data Bits library of documentation to build your own open data mashups, we have created a video that can be watched by clicking here.

Data Source Link

http://catalog.data.gov/dataset/public-budget-database-budget-authority-and-offsetting-receipts-1976-current

Available Access Formats

XLS

CSV

Sources and Modeling

Row Color	Derived Column
Row Color	Column Not Used by Open Data Bits

Logical Model

Hierarchies

agency > agency_name

Calculated Columns & Calculations

Name	DAX Expression	Type
Year Fiscal Date Key	=CONCATENATE(“10/01/”,(VALUE([YEAR])-1))	Calculated Column
Amount Total	Amt Total:=SUM([Value])	Calculation
YOY Growth %	YOY Growth %:=DIVIDE([Amt Total] – CALCULATE([Amt Total],PREVIOUSYEAR(‘Date'[Date])),CALCULATE([Amt Total],PREVIOUSYEAR(‘Date'[Date])))	Calculation