Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
I have 2 tables with a 1:many relationship. I have 1 table that has account name, units sold, and the year and month. I have another table with multiple months that has the budget data and I want to subtract them based on year and month and the account name. I want the formula to work form the duplicate accounts so I can see accounts that have been budgeted for but have no sales. Any help with this? Thanks!
Account Name | Year | Month | Budget | Sales | Difference between Budget & Sales |
t work right. Ideally I want
Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.