Forum Discussion

metcala's avatar
metcala
Icon for Helper III rankHelper III
2 years ago
Solved

Forecast/Actuals based on current date

Hi there   I currently have two separate tables one containing actual costs by project by month and the other containing the forecast by project by month.   Actuals   Project Month Cost ...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    metcala what is your backend source? If it is some SQL server, you can view it with the unique value, if not then you can easily do it in PQ, assuming the forecast table has all the projects.

     

    - right click on the forecast table and click reference, it will duplicate the forecast table

    - select project column, right-click, remove other columns

    - select the project column, and right-click, select remove duplicates.

     

    rename this table as you see fit and here you have a table with unique values of all the projects.

     

     

     

     

     

metcala's avatar
metcala
Icon for Helper III rankHelper III
2 years ago

parry2k Thanks so much for the quick reply that's really helpful.

 

What would be the best way to create the project dimension table? Every project will have a forecast so is there an easy way to just create a table using unique values from the forecast table project column?