How to minus columns in creating Measure

N

ndmalam

New Member
Joined
Sep 7, 2020
Messages
3
Office Version
  1. 2016
Platform
  1. Windows
I have a table which contains the purchase data of two years i e 2020 and 2020.
Now i created a pivot table in which i want to show "item", "Rate of "year1", "year2" and then a column showing difference of rate, i.e "year1-year2".
By Now in my pivot table, Rows contain "Item", Values contain "Rate" and Columns section contain "Date(year) "
I am trying to create a Measure that shiws the result of colum lable 2020-2021.
Please help. Best regards.
 

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
You must log in or register to reply here.

Similar threads

C
  • Question Question
Failing at creating DAX measure calculation :-(
Replies
1
Views
263
Matt Allington
M
I
  • Solved
DAX measure that filters a table to a single row and returns text from a specified column (Excel365)
Replies
3
Views
255
Insert_Key
I
B
  • Solved
Filter Power Pivot by the result of a measure
Replies
3
Views
688
bela_here
B
P
  • Question Question
PowePivot - Create a slicer of a measure or calculate values from one table using filter from another table
Replies
5
Views
681
RoryA
RoryA
A
  • Question Question
date slicer - between
Replies
0
Views
205
ajm
A

Forum statistics

Threads
1,223,713
Messages
6,174,043
Members
452,542
Latest member
Bricklin

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top