DAX Patterns: Budget

These are in-depth video lectures of the Budget pattern.

This pattern includes several coding techniques you may find useful for budgeting scenarios. The techniques do not apply only to budgeting. We use the budget as an example to show how to reallocate a measure at a different granularity, and how to combine measures coming from tables with different granularities into the same chart.

Collapse allCurriculum

  • Budget

    • About the Budget pattern
    • Introduction
    • The data model
    • Forecast allocation
    • Using the forecast measure
    • Showing actuals and forecasts on the same chart

Collection

This content is also available in the collection:
DAX Patterns collection
Student Rating
5.0
3 ratings
0%
0%
0%
0%
Student Reviews (3)
  • Mueez Ur Rehman Syed (Sep 24, 2022)

    It was exactly same as in my case so I enjoyed it a lot, I needed last quarters projection on which to base next year's budget. My company is operating in a logistics industry so its little bit complex, a lot of geographically dispersed locations, complex and unpredictable cost structure due to the major component of fuel cost.

  • Raj Venogopal (Mar 16, 2022)

    Excellent work

  • Peter Heller (Dec 27, 2020)

    Well documented and easy to follow but needs time to digest. The last date available appears to be a critical and pivotal technique in time intelligence. Excellent insight.