Forum Discussion

bigsky5829's avatar
bigsky5829
Frequent Visitor
5 years ago
Solved

Expanded Values Don't Match Values in Merged Table

This is what is merged into my query:   And this is what happens after I expand the values.  They are completely different (and wrong!)     What could possibly be going on here?  
Need Help
  • edhans's avatar
    edhans
    5 years ago

    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.

     

v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi bigsky5829 ,

Could not reproduce it in my side. How would the rank column be created, a custom column or just in the table initially.

 

Could you please consider sharing a sample file or some sample data without ant sensitive information for further dsicussion so that memebers in the community could help you better.

 

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