Dealing with Revenues minus Expenses in a Power Pivot table

alramirez — Wed, 26 Jul 2023 00:14:08 GMT

I'm trying to build a "pivot-able" Profit & Loss ("P&L") statement, which, so far, gives me nice, filtereable/sliceable Revenues and Expense subtotals that I can slice/dice/sort/etc. by cost center, location, GL account, etc. So far so good.

The problem I have is: the Grand totals of the pivot table are currently Revenues *plus* Expenses, which obviosusly doesn't make common business sense. What I need is to arrive at a Net Income that is equal to Revenues *minus* Expenses. Importantly, I need this Net Income to correspond only to the filters and slices applied to the pivot table.

How can I do that?

Re: Dealing with Revenues minus Expenses in a Power Pivot table

Anonymous — Wed, 26 Jul 2023 07:57:48 GMT

Hi alramirez ,

You calcualtion is based on your data model, please share a sample file with us and show us a screenshot with the result you want. This will make it easier for us to find the solution.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Dealing with Revenues *minus* Expenses in a Power Pivot table in DAX Commands and Tips

Dealing with Revenues *minus* Expenses in a Power Pivot table

Re: Dealing with Revenues *minus* Expenses in a Power Pivot table

topic Dealing with Revenues minus Expenses in a Power Pivot table in DAX Commands and Tips

Dealing with Revenues minus Expenses in a Power Pivot table

Re: Dealing with Revenues minus Expenses in a Power Pivot table