Need help on complex table/matrix structure

[Sunkari]

I need some DAX help on creating following structure of table/matrix. We need to replicate the exact structure.

Impression,EndActions & Downloads are metrics.

YTD= Year to Date

Current Period=Current Month

Period(Minus 1)=Previous Month

Period(Minus 2)=Two Months back data etc....

	Period(Minus 4)	Period(Minus 3)	Period(Minus 2)	Period(Minus 1)	Current Period	YTD
Impression
InitialResponses
EndActions
Downloads

[v-ljerr-msft]

Hi @Sunkari,

Could you post your table structures with some sample data, so that we can better assist on this issue? 

Regards

[Sunkari]

	Jan-17	Feb-17	March-17	April-17	CurrentMonth	YTD
Impressions	100	120	90	50	30	390
Initial Responses	90	100	70	40	20	320
EndActions	60	70	40	40	10	220
Downloads	40	50	30	20	5	145

[v-ljerr-msft]

Hi @Sunkari,

Could you post your real table structures in your data model(like the Calendar table, Sales table, and Product table etc)? 

Regards