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

Available Access Formats


Sources and Modeling

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

Logical Model


  • 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

Examples for Reference

Open Data Bits – Office of Management and Budget Data Visualization