Forum Discussion

sashasneg3's avatar
sashasneg3
Frequent Visitor
8 years ago
Solved

Different time aggregation for different measures within the same table?

Hello,   I did achieve the result visually but am very uncomfortable with how I did it: it seems like I've hit a wall in searching for a solution to create the following table:                   ...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    sashasneg3,

     

    Hi Aleksandra,

     

    There are measures in the rows and columns in your example. Measures are dynamic. So you can't a visual that is exactly the same with your example. Maybe you can try it like this.

    1. The column could be dates from a column of one table.

    2. The visualization is a Matrix.

    3. The Columns field is date.

    4. The Value field is the results you want.

    5. Enable "Show on rows" in the settings of Matrix.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

     

     

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

sashasneg3,

 

Hi Aleksandra,

 

There are measures in the rows and columns in your example. Measures are dynamic. So you can't a visual that is exactly the same with your example. Maybe you can try it like this.

1. The column could be dates from a column of one table.

2. The visualization is a Matrix.

3. The Columns field is date.

4. The Value field is the results you want.

5. Enable "Show on rows" in the settings of Matrix.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale