Forum Discussion
Expanded Values Don't Match Values in Merged Table
Try flushing the PQ cache, or force it to refresh. You can clear the cache in the Data Load settings. It might be expanding the correct values and showing you the incorrect ones.
If that isn't it, then v-yingjl is correct. Share data. There is something else going on that isn't easy to reproduce.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
Try flushing the PQ cache, or force it to refresh. You can clear the cache in the Data Load settings. It might be expanding the correct values and showing you the incorrect ones.
If that isn't it, then v-yingjl is correct. Share data. There is something else going on that isn't easy to reproduce.
How to get good help fast. Help us help you.
How To Ask A Technical Question If you Really Want An Answer
How to Get Your Question Answered Quickly - Give us a good and concise explanation
How to provide sample data in the Power BI Forum - Provide data in a table format per the link, or share an Excel/CSV file via OneDrive, Dropbox, etc.. Provide expected output using a screenshot of Excel or other image. Do not provide a screenshot of the source data. I cannot paste an image into Power BI tables.
I cleared the cache and I cannot reproduce the error any longer. The data in the preview was correct; the expanded data is incorrect. I have sanitized data and the M code I can post, but it appears just to be a caching issue.
Excellent bigsky5829 - glad that was the issue. I rarely have to clear the cache, but it isn't never, so just remember that feature exists. Hope the rest of your project goes a bit smoother. 😁