Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Combining Linear/Nonlinear Budgets

My current data assumes that every "Task" has a linear budget. Some of the tasks do not.  Below is an example of the tables I'm working with. The Budget Table gives the budget linearly, regardless o...
lbendlin's avatar
lbendlin
Super User
4 years ago

That should be doable - maybe even by combining both budget tables into one.

 

Please provide sanitized sample data that fully covers your issue. I can only help you with meaningful sample data.
Please paste the data into a table in your post or use one of the file services like OneDrive or Google Drive.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I've provided the additional information in the replies. I am pulling the Budget Table data from Analysis Services and the Nonlinear Budget Table from an Excel file.