Forum Discussion
Column imported from SQL not showing accurate data when summarised for months
I have a gross profit % column in my datatset (imported from SQL) that is not showing the correct numbers when I summarize all days values, as in try to show total gross profit % for some month of the year. However, it shows the correct values in excel. I also created a measure in power bi for gross profit % which is showing the correct values but the original column is not
Without a model or source data available troubleshooting is difficult. The following learning resource from EnterpriseDNA on Calculating Percent Profit Margins Using DAX In Power BI covers the topic from end to end using best practices.
3 Replies
Are you meaning that the SQL View that is being connected to is not including the correct table data or summaries? If that is the case, then you need to look at what is being selected and handle it upstream. If you would like assistance from members of the Community Forum, then please add a work-in-progress PowerBI Desktop file and any source data necessary to cleanly refresh the model in Excel format.
I am sorry for being unclear. SQL View has the correct table data. All the other columns are accurate and match with my dataset in SQL. It is just the gross profit % column that is shwoing different numbers. I am not allowed to share data or files but I am posting a screenshot fo a table I made to make it clearer. Here, Gross Profit % column is a measure I made whcih matches perfectly wiht the original dataset numbers (in sql). The other two columns are the ones I get from dataset and they show different numbers
Without a model or source data available troubleshooting is difficult. The following learning resource from EnterpriseDNA on Calculating Percent Profit Margins Using DAX In Power BI covers the topic from end to end using best practices.
