dax

Question

Good day&nbsp;I'm looking for assistanceplease&nbsp; with a measure that I require to return the "Cost"&nbsp; (sum of Cost) where TableA[Allocation month] = TableB[Report date] less one month. Basically I am looking to return the bold numbers below (sum of Cost at each date) in a format that I can use as a line on a chart (with the allocation month as the axis):&nbsp;&nbsp;&nbsp;Report Date&nbsp;&nbsp;JanFebMarAprMayJun&nbsp;Jan246253220401145188&nbsp;Feb&nbsp;473267326170239341&nbsp;Mar285190492349191381Allocation monthApr212152339280395110&nbsp;May213118105494103331&nbsp;Jun166356225395366424&nbsp;Jul366253260318462467&nbsp;Aug362372243490249213&nbsp;Sep326283368334202240&nbsp;Oct328484452295413465&nbsp;Nov162219271415402172&nbsp;Dec270218232200371439&nbsp;Thank you for any help

anonymous · Answer

Hi&nbsp;Kletzy,
&nbsp;
Please share some sample data for test.
&nbsp;
Regards,
Xiaoxin Sheng

Forum Discussion

dax

1 Reply

Related content

Dax

DAX

DAX Behavior

DAX Formula Help

DAX

		Report Date
		Jan	Feb	Mar	Apr	May	Jun
	Jan	246	253	220	401	145	188
	Feb	473	267	326	170	239	341
	Mar	285	190	492	349	191	381
Allocation month	Apr	212	152	339	280	395	110
	May	213	118	105	494	103	331
	Jun	166	356	225	395	366	424
	Jul	366	253	260	318	462	467
	Aug	362	372	243	490	249	213
	Sep	326	283	368	334	202	240
	Oct	328	484	452	295	413	465
	Nov	162	219	271	415	402	172
	Dec	270	218	232	200	371	439