Forum Discussion

Sunkari's avatar
Sunkari
Responsive 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
Microsoft 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
    Responsive Resident
    9 years ago
     Jan-17Feb-17March-17April-17CurrentMonthYTD
    Impressions100120905030390
    Initial Responses90100704020320
    EndActions6070404010220
    Downloads405030205145
    • v-ljerr-msft's avatar
      v-ljerr-msft
      Microsoft 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