Forum Discussion

arumel's avatar
arumel
Frequent Visitor
2 years ago

Multi year budgets v actual

Hi all, new to power BI and need some help with the intial setup for a dashboard - Essentially this is a budget to expense report.   I have 2 fact tables:   1: Budget = Budget data is on an annua...
Need Help
danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi arumel ,

 

In your Actuals table, add a year column either using M or DAX. Then create a Year dimensions table and a Department dimension table. Relate both dimension tables to the fact tables. Use the dimension columns from the dimensions table in your visuals.  Please see attached pbix for details.

 

arumel's avatar
arumel
Frequent Visitor
2 years ago

Thanks for your help .. im going to have a play with this tonight .. will let you know how i get on

 

Regards

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    arumel  Thanks for your contribution on this thread.

    Hi arumel ,

    Have you got the solution? If yes, could you please mark the helpful post as Answered? Thank you.

     

    Best Regards