Forum Discussion
Solved
Merging two pbix files results in summarized data giving wrong result
Hi there, I am new to Power BI, any advice/solution on this problem is much appreciated. I am having two pbix files "file1" and "file2" pointing to different products "A" and "B" respectively. T...
nsa and have you confirmed that the relationship to the Calendar table is the same between both models?
smpa01
Community Champion
Community Championnsa one of the many things can go sideways are, when you change your dataset, the ordering of the column changes which can make things go north. I had this issue when I changed the data source in Query1 from sourceA to a very similar sourceB.
The original order
<col1>,<col2>,<col3>got reordered as
<col3>,<col1>,<col2>
Check that is not the case with you and if yes, check the here , worked for me.