Forum Discussion

Sunkari's avatar
Sunkari
Icon for Responsive Resident rankResponsive Resident
9 years ago

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...
Need Help
Tips and Tricks
v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Sunkari,

 

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

 

Regards

Sunkari's avatar
Sunkari
Icon for Responsive Resident rankResponsive Resident
9 years ago
 Jan-17Feb-17March-17April-17CurrentMonthYTD
Impressions100120905030390
Initial Responses90100704020320
EndActions6070404010220
Downloads405030205145
  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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