Forum Discussion
difference between columns in pivot table
Time was, in a power pivot we could make an additional item that was the difference between two other columns in a pivot table. So, if I had a pivot table with budget and actual, I can make a differ...
Hi Ffitzpatrick47,
>> Is there a way to do something similar to this in power pivot without making three measures, two for budget and actual, and then one to calculate the difference?
If my understanding is right, you want to know how to achieve the similar result in Power BI, right?
If it is, what your resource table look like? Could you please share your sample table, and post a pivot table screenshot, so that we can reproduce your scenario and the similar result in Power BI desktop.
Best Regards,
Angelila