Hi good day can some help me on my measure, i have a table and i want to sum the total Trade per week. The column TRADE_Max Count/Week is one of my measure. The Total Trade in Week 22 is from 17+30+20 = 67, Week 23 is from 16+17+117=150 and so on. DATEWeek No:TradeTRADE_Max Count/WeekTotal Trade5/26/2025 0:0022Civil17675/26/2025 0:0022Mech30675/26/2025 0:0022Civil17675/26/2025 0:0022Civil17675/26/2025 0:0022Mech30675/26/2025 0:0022Mech30675/26/2025 0:0022Mech30675/26/2025 0:0022Elect20675/27/2025 0:0022Elect20675/27/2025 0:0022Elect20675/27/2025 0:0022Elect20676/2/2025 0:0023Mech161506/2/2025 0:0023Civil171506/2/2025 0:0023Elect1171506/2/2025 0:0023Mech161506/2/2025 0:0023Elect1171506/2/2025 0:0023Elect1171506/2/2025 0:0023Mech161506/2/2025 0:0023Civil171506/2/2025 0:0023Civil171506/2/2025 0:0023Civil171506/3/2025 0:0023Civil171506/3/2025 0:0023Civil171506/9/2025 0:0024Mech151306/9/2025 0:0024Scaff251306/9/2025 0:0024Civil901306/9/2025 0:0024Civil901306/9/2025 0:0024Civil901306/9/2025 0:0024Civil901306/9/2025 0:0024Mech151306/9/2025 0:0024Mech151306/9/2025 0:0024Mech151306/9/2025 0:0024Scaff251306/9/2025 0:0024Scaff251306/9/2025 0:0024Scaff25130Thank youDESIRED OUTPUTDATEWeek No:TradeTRADE_Max Count/WeekTotal Trade5/26/2025 0:0022Civil17675/26/2025 0:0022Mech30675/26/2025 0:0022Civil17675/26/2025 0:0022Civil17675/26/2025 0:0022Mech30675/26/2025 0:0022Mech30675/26/2025 0:0022Mech30675/26/2025 0:0022Elect20675/27/2025 0:0022Elect20675/27/2025 0:0022Elect20675/27/2025 0:0022Elect20676/2/2025 0:0023Mech161506/2/2025 0:0023Civil171506/2/2025 0:0023Elect1171506/2/2025 0:0023Mech161506/2/2025 0:0023Elect1171506/2/2025 0:0023Elect1171506/2/2025 0:0023Mech161506/2/2025 0:0023Civil171506/2/2025 0:0023Civil171506/2/2025 0:0023Civil171506/3/2025 0:0023Civil171506/3/2025 0:0023Civil171506/9/2025 0:0024Mech151306/9/2025 0:0024Scaff251306/9/2025 0:0024Civil901306/9/2025 0:0024Civil901306/9/2025 0:0024Civil901306/9/2025 0:0024Civil901306/9/2025 0:0024Mech151306/9/2025 0:0024Mech151306/9/2025 0:0024Mech151306/9/2025 0:0024Scaff251306/9/2025 0:0024Scaff251306/9/2025 0:0024Scaff25130

Hi AllanBerces, Thank you Jihwan_Kim techies, for your insights. I have reproduced your scenario using the sample data and obtained the output shown below. I have also attached the pbix file for your reference. hope this helps Thank you.

AllanBerces

Post Prodigy

11 months ago

Solved

Total Trade per Week

Hi good day can some help me on my measure, i have a table and i want to sum the total Trade per week. The column TRADE_Max Count/Week is one of my measure. The Total Trade in Week 22 is from 17+30+20 = 67, Week 23 is from 16+17+117=150 and so on.

DATE	Week No:	Trade	TRADE_Max Count/Week	Total Trade
5/26/2025 0:00	22	Civil	17	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Civil	17	67
5/26/2025 0:00	22	Civil	17	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Elect	20	67
5/27/2025 0:00	22	Elect	20	67
5/27/2025 0:00	22	Elect	20	67
5/27/2025 0:00	22	Elect	20	67
6/2/2025 0:00	23	Mech	16	150
6/2/2025 0:00	23	Civil	17	150
6/2/2025 0:00	23	Elect	117	150
6/2/2025 0:00	23	Mech	16	150
6/2/2025 0:00	23	Elect	117	150
6/2/2025 0:00	23	Elect	117	150
6/2/2025 0:00	23	Mech	16	150
6/2/2025 0:00	23	Civil	17	150
6/2/2025 0:00	23	Civil	17	150
6/2/2025 0:00	23	Civil	17	150
6/3/2025 0:00	23	Civil	17	150
6/3/2025 0:00	23	Civil	17	150
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Scaff	25	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Scaff	25	130
6/9/2025 0:00	24	Scaff	25	130
6/9/2025 0:00	24	Scaff	25	130

Thank you

DESIRED OUTPUT

DATE	Week No:	Trade	TRADE_Max Count/Week	Total Trade
5/26/2025 0:00	22	Civil	17	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Civil	17	67
5/26/2025 0:00	22	Civil	17	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Mech	30	67
5/26/2025 0:00	22	Elect	20	67
5/27/2025 0:00	22	Elect	20	67
5/27/2025 0:00	22	Elect	20	67
5/27/2025 0:00	22	Elect	20	67
6/2/2025 0:00	23	Mech	16	150
6/2/2025 0:00	23	Civil	17	150
6/2/2025 0:00	23	Elect	117	150
6/2/2025 0:00	23	Mech	16	150
6/2/2025 0:00	23	Elect	117	150
6/2/2025 0:00	23	Elect	117	150
6/2/2025 0:00	23	Mech	16	150
6/2/2025 0:00	23	Civil	17	150
6/2/2025 0:00	23	Civil	17	150
6/2/2025 0:00	23	Civil	17	150
6/3/2025 0:00	23	Civil	17	150
6/3/2025 0:00	23	Civil	17	150
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Scaff	25	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Civil	90	130
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Mech	15	130
6/9/2025 0:00	24	Scaff	25	130
6/9/2025 0:00	24	Scaff	25	130
6/9/2025 0:00	24	Scaff	25	130

Need Help

v-saisrao-msft
11 months ago
Hi AllanBerces,

Thank you Jihwan_Kim techies, for your insights.

I have reproduced your scenario using the sample data and obtained the output shown below. I have also attached the pbix file for your reference.

hope this helps

Thank you.
4812421_Trade.pbix20 KB

8 Replies

v-saisrao-msft
Community Support
11 months ago
Hi AllanBerces,

Thank you Jihwan_Kim techies, for your insights.

I have reproduced your scenario using the sample data and obtained the output shown below. I have also attached the pbix file for your reference.

hope this helps

Thank you.
4812421_Trade.pbix20 KB
v-saisrao-msft
Community Support
11 months ago
Hi AllanBerces,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.
Jihwan_Kim
Super User
11 months ago
Hi,

Please check the below picture and the attached pbix file.

It is for creating a calculated column.

Total Trade CC = VAR _week = Data[Week No:] VAR _t = SUMMARIZE ( FILTER ( Data, Data[Week No:] = _week ), Data[Week No:], Data[TRADE_Max Count/Week] ) RETURN SUMX ( _t, Data[TRADE_Max Count/Week] )
AllanBerces.pbix21 KB
- AllanBerces
  Post Prodigy
  11 months ago
  Hi Jihwan_Kim thank you very much for the reply, but the column
  TRADE_Max Count/Week is from measure.
  - Jihwan_Kim
    Super User
    11 months ago
    Hi,
    
    Please share your sample pbix file, and then I can try to look into it.
    
    Thank you.
techies
Super User
11 months ago
Hi AllanBerces please try this measure

Total trade=

CALCULATE (

SUMX (

VALUES ( Sheet8[Trade] ),

[TRADE_Max Count/Week]

),

REMOVEFILTERS ( Sheet8[Trade] )

)
- AllanBerces
  Post Prodigy
  11 months ago
  Hi techies thank you for the reply but is show blank
  - techies
    Super User
    11 months ago
    just to confirm, yu have a date table?

Forum Discussion

Total Trade per Week

8 Replies

Related content

Calculate previous week total and previous 2 weeks total

Running totals per week

Rolling 4 Week Total

Cumulative Total

Week over week measure