Forum Discussion
Need help on complex table/matrix structure
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 |
3 Replies
Hi Sunkari,
Could you post your table structures with some sample data, so that we can better assist on this issue? :smileyhappy:
Regards
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 Hi Sunkari,
Could you post your real table structures in your data model(like the Calendar table, Sales table, and Product table etc)? :smileyhappy:
Regards
