Calculate difference between values in one table based on column

Question

Hello,&nbsp;Would you be able to help me resolve the issue where I would like to calculate and show the difference in prices which happened from a week ago (2weeks and 3 weeks) by today and show what is the results for it. Below is the example data.&nbsp;&nbsp;TitlePriceSalesDateCategoryWeeksCDT376,33109.05.2022Day-Trips&nbsp;TodayCDT376,33109.05.2022Unique-Experiences&nbsp;TodayCDT376,33109.05.2022City-Tours-Attraction-Product-Category&nbsp;TodayBMF95,415109.05.2022Walking-Tours-Attraction-Product-Category&nbsp;TodayBSS37,631609.05.2022Walking-Tours-Attraction-Product-Category&nbsp;TodayBSS37,631609.05.2022Cultural-Tours-Attraction-Product-Category&nbsp;TodayBMF95,415109.05.2022Art-and-Culture&nbsp;TodayBSS37,631609.05.2022Audio-Guided-Tours&nbsp;TodayBSS37,631609.05.2022Unique-Experiences&nbsp;TodayBMF95,415109.05.2022Kid-Friendly&nbsp;TodayBAT75,6257509.05.2022Global&nbsp;TodayBAT75,6257509.05.2022Tours-and-Sightseeing&nbsp;TodayBAT75,6257509.05.2022Likely-To-Sell-Out-Viator-Market-Driven-Mercha&nbsp;TodayBAT75,6257509.05.2022Bus-and-Minivan-Tours&nbsp;TodayBAT75,6257509.05.2022Luxury-Tours&nbsp;TodayBAT75,6257509.05.2022Food-Wine-and-Nightlife&nbsp;TodayBAT75,6257509.05.2022Audio-Guided-Tours&nbsp;TodayCDT383,68102.05.2022Day-Trips1 Week AgoCDT383,68102.05.2022Unique-Experiences1 Week AgoBMF95,445102.05.2022Walking-Tours-Attraction-Product-Category1 Week AgoBSS38,371602.05.2022Cultural-Tours-Attraction-Product-Category1 Week AgoBMF95,445102.05.2022Art-and-Culture1 Week AgoBSS38,371602.05.2022Audio-Guided-Tours1 Week AgoBSS38,371602.05.2022Unique-Experiences1 Week AgoBMF95,445102.05.2022Kid-Friendly1 Week AgoBAT77,0956102.05.2022Global1 Week AgoBAT77,0956102.05.2022Tours-and-Sightseeing1 Week AgoBAT77,0956102.05.2022Likely-To-Sell-Out-Viator-Market-Driven-Mercha1 Week AgoBAT77,0956102.05.2022Bus-and-Minivan-Tours1 Week AgoBAT77,0956102.05.2022Luxury-Tours1 Week AgoBAT77,0956102.05.2022Food-Wine-and-Nightlife1 Week AgoBAT77,0956102.05.2022Audio-Guided-Tours1 Week AgoCDT391,66125.04.2022Day-Trips2 Weeks AgoCDT391,66125.04.2022Full-day-Tours2 Weeks AgoCDT391,66125.04.2022Unique-Experiences2 Weeks AgoCDT391,66125.04.2022City-Tours-Attraction-Product-Category2 Weeks AgoBMF97,745125.04.2022Walking-Tours-Attraction-Product-Category2 Weeks AgoBSS39,171625.04.2022Cultural-Tours-Attraction-Product-Category2 Weeks AgoBMF97,745125.04.2022Art-and-Culture2 Weeks AgoBSS39,171625.04.2022Audio-Guided-Tours2 Weeks AgoBSS39,171625.04.2022Unique-Experiences2 Weeks AgoBMF97,745125.04.2022Kid-Friendly2 Weeks AgoBAT78,754225.04.2022Tours-and-Sightseeing2 Weeks AgoBAT78,754225.04.2022Bus-and-Minivan-Tours2 Weeks AgoBAT78,754225.04.2022Luxury-Tours2 Weeks AgoBAT78,754225.04.2022Food-Wine-and-Nightlife2 Weeks AgoBAT78,754225.04.2022Audio-Guided-Tours2 Weeks AgoCDT397,48119.04.2022Day-TripsOlderCDT397,48119.04.2022Unique-ExperiencesOlderBMF97,485119.04.2022Walking-Tours-Attraction-Product-CategoryOlderBSS39,751619.04.2022Walking-Tours-Attraction-Product-CategoryOlderBSS39,751619.04.2022Cultural-Tours-Attraction-Product-CategoryOlderBMF97,485119.04.2022Art-and-CultureOlderBSS39,751619.04.2022Audio-Guided-ToursOlderBSS39,751619.04.2022Unique-ExperiencesOlderBMF97,485119.04.2022Kid-FriendlyOlderBAT79,8752919.04.2022Tours-and-SightseeingOlderBAT79,8752919.04.2022Bus-and-Minivan-ToursOlderBAT79,8752919.04.2022Luxury-ToursOlderBAT79,8752919.04.2022Audio-Guided-ToursOlderCDT397,48118.04.2022Day-Trips3 Weeks AgoCDT397,48118.04.2022Unique-Experiences3 Weeks AgoBMF97,485118.04.2022Walking-Tours-Attraction-Product-Category3 Weeks AgoBSS39,751618.04.2022Walking-Tours-Attraction-Product-Category3 Weeks AgoBSS39,751618.04.2022Cultural-Tours-Attraction-Product-Category3 Weeks AgoBMF97,485118.04.2022Art-and-Culture3 Weeks AgoBSS39,751618.04.2022Audio-Guided-Tours3 Weeks AgoBSS39,751618.04.2022Unique-Experiences3 Weeks AgoBMF97,485118.04.2022Kid-Friendly3 Weeks AgoBAT79,8752918.04.2022Tours-and-Sightseeing3 Weeks AgoBAT79,8752918.04.2022Bus-and-Minivan-Tours3 Weeks AgoBAT79,8752918.04.2022Luxury-Tours3 Weeks AgoBAT79,8752918.04.2022Audio-Guided-Tours3 Weeks Ago&nbsp;I really appreciate your help,Thanks!

davehus · Accepted Answer

Hi&nbsp;wojbal&nbsp;,&nbsp;Use the following&nbsp;&nbsp;Todays Price = CALCULATE(SUM(Test[Price]), KEEPFILTERS(Test[Weeks] = "Today"))Price 1 Weeks Ago = CALCULATE(SUM(Test[Price]), KEEPFILTERS(Test[Weeks] = "1 Week Ago"))Price 2 Weeks Ago = CALCULATE(SUM(Test[Price]), KEEPFILTERS(Test[Weeks] = "2 Weeks Ago"))Price 3 Weeks Ago = CALCULATE(SUM(Test[Price]), KEEPFILTERS(Test[Weeks] = "3 Weeks Ago"))&nbsp;And subtract as required.&nbsp;&nbsp;

Forum Discussion

Calculate difference between values in one table based on column

1 Reply

Related content

Dynamic Calculation Different Period

Different Calculations

1. How to add two different calculated columns of two different table

Calculating Differences

How to add two different calculated columns of two different table

Title	Price	Sales	Date	Category	Weeks
CDT	376,33	1	09.05.2022	Day-Trips	Today
CDT	376,33	1	09.05.2022	Unique-Experiences	Today
CDT	376,33	1	09.05.2022	City-Tours-Attraction-Product-Category	Today
BMF	95,41	51	09.05.2022	Walking-Tours-Attraction-Product-Category	Today
BSS	37,63	16	09.05.2022	Walking-Tours-Attraction-Product-Category	Today
BSS	37,63	16	09.05.2022	Cultural-Tours-Attraction-Product-Category	Today
BMF	95,41	51	09.05.2022	Art-and-Culture	Today
BSS	37,63	16	09.05.2022	Audio-Guided-Tours	Today
BSS	37,63	16	09.05.2022	Unique-Experiences	Today
BMF	95,41	51	09.05.2022	Kid-Friendly	Today
BAT	75,62	575	09.05.2022	Global	Today
BAT	75,62	575	09.05.2022	Tours-and-Sightseeing	Today
BAT	75,62	575	09.05.2022	Likely-To-Sell-Out-Viator-Market-Driven-Mercha	Today
BAT	75,62	575	09.05.2022	Bus-and-Minivan-Tours	Today
BAT	75,62	575	09.05.2022	Luxury-Tours	Today
BAT	75,62	575	09.05.2022	Food-Wine-and-Nightlife	Today
BAT	75,62	575	09.05.2022	Audio-Guided-Tours	Today
CDT	383,68	1	02.05.2022	Day-Trips	1 Week Ago
CDT	383,68	1	02.05.2022	Unique-Experiences	1 Week Ago
BMF	95,44	51	02.05.2022	Walking-Tours-Attraction-Product-Category	1 Week Ago
BSS	38,37	16	02.05.2022	Cultural-Tours-Attraction-Product-Category	1 Week Ago
BMF	95,44	51	02.05.2022	Art-and-Culture	1 Week Ago
BSS	38,37	16	02.05.2022	Audio-Guided-Tours	1 Week Ago
BSS	38,37	16	02.05.2022	Unique-Experiences	1 Week Ago
BMF	95,44	51	02.05.2022	Kid-Friendly	1 Week Ago
BAT	77,09	561	02.05.2022	Global	1 Week Ago
BAT	77,09	561	02.05.2022	Tours-and-Sightseeing	1 Week Ago
BAT	77,09	561	02.05.2022	Likely-To-Sell-Out-Viator-Market-Driven-Mercha	1 Week Ago
BAT	77,09	561	02.05.2022	Bus-and-Minivan-Tours	1 Week Ago
BAT	77,09	561	02.05.2022	Luxury-Tours	1 Week Ago
BAT	77,09	561	02.05.2022	Food-Wine-and-Nightlife	1 Week Ago
BAT	77,09	561	02.05.2022	Audio-Guided-Tours	1 Week Ago
CDT	391,66	1	25.04.2022	Day-Trips	2 Weeks Ago
CDT	391,66	1	25.04.2022	Full-day-Tours	2 Weeks Ago
CDT	391,66	1	25.04.2022	Unique-Experiences	2 Weeks Ago
CDT	391,66	1	25.04.2022	City-Tours-Attraction-Product-Category	2 Weeks Ago
BMF	97,74	51	25.04.2022	Walking-Tours-Attraction-Product-Category	2 Weeks Ago
BSS	39,17	16	25.04.2022	Cultural-Tours-Attraction-Product-Category	2 Weeks Ago
BMF	97,74	51	25.04.2022	Art-and-Culture	2 Weeks Ago
BSS	39,17	16	25.04.2022	Audio-Guided-Tours	2 Weeks Ago
BSS	39,17	16	25.04.2022	Unique-Experiences	2 Weeks Ago
BMF	97,74	51	25.04.2022	Kid-Friendly	2 Weeks Ago
BAT	78,7	542	25.04.2022	Tours-and-Sightseeing	2 Weeks Ago
BAT	78,7	542	25.04.2022	Bus-and-Minivan-Tours	2 Weeks Ago
BAT	78,7	542	25.04.2022	Luxury-Tours	2 Weeks Ago
BAT	78,7	542	25.04.2022	Food-Wine-and-Nightlife	2 Weeks Ago
BAT	78,7	542	25.04.2022	Audio-Guided-Tours	2 Weeks Ago
CDT	397,48	1	19.04.2022	Day-Trips	Older
CDT	397,48	1	19.04.2022	Unique-Experiences	Older
BMF	97,48	51	19.04.2022	Walking-Tours-Attraction-Product-Category	Older
BSS	39,75	16	19.04.2022	Walking-Tours-Attraction-Product-Category	Older
BSS	39,75	16	19.04.2022	Cultural-Tours-Attraction-Product-Category	Older
BMF	97,48	51	19.04.2022	Art-and-Culture	Older
BSS	39,75	16	19.04.2022	Audio-Guided-Tours	Older
BSS	39,75	16	19.04.2022	Unique-Experiences	Older
BMF	97,48	51	19.04.2022	Kid-Friendly	Older
BAT	79,87	529	19.04.2022	Tours-and-Sightseeing	Older
BAT	79,87	529	19.04.2022	Bus-and-Minivan-Tours	Older
BAT	79,87	529	19.04.2022	Luxury-Tours	Older
BAT	79,87	529	19.04.2022	Audio-Guided-Tours	Older
CDT	397,48	1	18.04.2022	Day-Trips	3 Weeks Ago
CDT	397,48	1	18.04.2022	Unique-Experiences	3 Weeks Ago
BMF	97,48	51	18.04.2022	Walking-Tours-Attraction-Product-Category	3 Weeks Ago
BSS	39,75	16	18.04.2022	Walking-Tours-Attraction-Product-Category	3 Weeks Ago
BSS	39,75	16	18.04.2022	Cultural-Tours-Attraction-Product-Category	3 Weeks Ago
BMF	97,48	51	18.04.2022	Art-and-Culture	3 Weeks Ago
BSS	39,75	16	18.04.2022	Audio-Guided-Tours	3 Weeks Ago
BSS	39,75	16	18.04.2022	Unique-Experiences	3 Weeks Ago
BMF	97,48	51	18.04.2022	Kid-Friendly	3 Weeks Ago
BAT	79,87	529	18.04.2022	Tours-and-Sightseeing	3 Weeks Ago
BAT	79,87	529	18.04.2022	Bus-and-Minivan-Tours	3 Weeks Ago
BAT	79,87	529	18.04.2022	Luxury-Tours	3 Weeks Ago
BAT	79,87	529	18.04.2022	Audio-Guided-Tours	3 Weeks Ago