Forum Discussion
Column imported from SQL not showing accurate data when summarised for months
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.
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.