Forum Discussion

swise001's avatar
swise001
Continued Contributor
5 years ago
Solved

Aggregation Table - Issue selecting detail column

I've created a direct-query aggregation table with 3 aggregations on DateKey   Sum of QTY Sum of Sales Count of Sales:  Here is an image of the agg table creation (done in Power Query)   ...
Need Help
  • swise001's avatar
    swise001
    5 years ago

    The source table data type was ultimately the source of the issue. 

     

    I updated the source View to cast "Qty" in the same format as Sales.  Once updated, the aggregation table then allowed me to select Qty for that column.  

swise001's avatar
swise001
Continued Contributor
5 years ago

The source table data type was ultimately the source of the issue. 

 

I updated the source View to cast "Qty" in the same format as Sales.  Once updated, the aggregation table then allowed me to select Qty for that column.  

Watsky's avatar
Watsky
Solution Sage
5 years ago

swise001 Awesome! You just needed a nudge 😉