Forum Discussion

suman-kumar's avatar
suman-kumar
New Member
8 years ago

Data type conversion from non aggregate to aggregate

Hi Team,

 

I have created my Power BI account online where  I have imported Excel data.

There are some measures which should be measures but it is in dimesion means without Aggregate function. Here I have attached a screen shot.

 

Can you please help me to solve this issue.?

 

Thanks

Suman

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    Hi suman-kumar，

     

    Two things need to be checked:

    1. There're no measures in your screenshot, please check if you have created measures in your excel file using power pivot.

    2. No aggregation symbol means your data can't be aggregated, please check if your data type in your table can be aggregated(e.g.: number type)

     

    Regards,

    Jimmy Tao