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=C...
| 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