cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rajendraongole1 Regular Visitor
Regular Visitor

Difference in column details in sales

Hi

 

I have two columns with sales 2018 & sales 2019

 

one of the column is shown with aggregate symbol another one is not showing anything. 

I have checked with datatypes and all which is reflecting the same. how can i show both the columns either in aggregate or without that symbol?

 

pls suggest. 

2 ACCEPTED SOLUTIONS

Accepted Solutions
rajendraongole1 Regular Visitor
Regular Visitor

Re: Difference in column details in sales

Hi Cherry- I have just followed the thread that you have shared. i have throughly cross checked the data that is available in my end. there are some - and () which is appeared in that column and at power query level i have changed the datatype to fixed decimal and now it it reporting the aggregation data while checking it at front end. 

 

Thanks for your help and support.

 

Rajendra

Highlighted
Community Support Team
Community Support Team

Re: Difference in column details in sales

Hi @rajendraongole1 ,

It seems that you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Community Support Team
Community Support Team

Re: Difference in column details in sales

Hi @rajendraongole1 ,

What aggregate symbol do you mean?

Do you mean the yellow highlight in the picture below?

Capture.PNG

If it is, could you share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

In addition, you could refer to this similar thread.

Best  Regards,

Cherry

 

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rajendraongole1 Regular Visitor
Regular Visitor

Re: Difference in column details in sales

Hi

 

Yes correct, i have checked in both the columns data sales 2018 & sales 2019. there is no characters in that data. but one of the field is showing as aggregation symbol another one not . it quite strange to me.

 

do i need to cross check or change datatype anywhere once i pull the data into power bi?

 

Please suggest

 

Regards,

Rajendra

Community Support Team
Community Support Team

Re: Difference in column details in sales

Hi @rajendraongole1 ,

What is your data source?

If it is convenient, could you share the dummy pbix file which can reproduce the scenario, so that we can help further investigate on it?

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
rajendraongole1 Regular Visitor
Regular Visitor

Re: Difference in column details in sales

Hi Cherry- I have just followed the thread that you have shared. i have throughly cross checked the data that is available in my end. there are some - and () which is appeared in that column and at power query level i have changed the datatype to fixed decimal and now it it reporting the aggregation data while checking it at front end. 

 

Thanks for your help and support.

 

Rajendra

Highlighted
Community Support Team
Community Support Team

Re: Difference in column details in sales

Hi @rajendraongole1 ,

It seems that you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 122 members 1,567 guests
Please welcome our newest community members: