Adding columns

[S95]

Good morning,

I'm working on creating a report that shows daily sales broken down by employee, date, and location. I have a table that has all of this already broken down, but I need to calculate adjusted net sales from a new table that has adjustments. I tried to do this with a new measure: Adjusted net Sales = Sum(Query1[net_sales) + sum(Adjustments[amount]), and while it does add/remove the adjustments based on the employee, it is performing the adjustment on each entry for the employee instead of just that date and location. I'm pretty sure this is a simple thing I'm missing, but I'm still learning PowerBI so its a matter of me not fully understanding expressions.

For reference, both tables have the following columns: Date, Location, and Employee. The query1 table also has a net_sales, whereas the adjustment table has an amount column.

Any help is greatly appreciated.

[amitchandak]

@S95 , You formula should work fine, all three dimensions Date, Location, and Employee. It should just depend on what is used in visual.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[S95 · Accepted solution]

I apologize but I actually figured it out while I was putting a test file together. My file was conflicting the two tables in regards to the date. I created a table that was specifically a list of dates and added relationships from both original sheets and this appears to have solved my problem.

[v-deddai1-msft]

Hi @S95  ,

I'm glad that you have solved your issue by yourself. Would you mark useful reply as answer to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[S95]

My apologies as I've been off for a few days.

[S95]

Let me create a sample file and I'll upload it.

Thanks,