Forum Discussion

Danapa's avatar
Danapa
Frequent Visitor
9 years ago

Couldn't get the simple sum function for a column

Hi,  I have this sales table with the sales amount as one of the columns. And I have the date as a column. The sales table has the relationship connected to a calendar table. I need to total the sal...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
9 years ago

Hi Danapa,

 

I remembered I met the same issue when I used the Power BI Desktop version 2.40.4554.361, but after I updated to the new version

2.40.4554.463, I didn't encounter this issue. Please update the desktop to this new version to check if the issue persists: https://www.microsoft.com/en-us/download/details.aspx?id=45331.

 

Best Regards,
Qiuyun Yu

Danapa's avatar
Danapa
Frequent Visitor
9 years ago

Thank you for the info. I updated the version and the issue still persists. :smileysad:

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi Danapa,

     

    Did the data grayed out in Data tab frequently or intermittently in latest desktop version?

     

    Best Regards,
    Qiuyun Yu

    • Danapa's avatar
      Danapa
      Frequent Visitor
      9 years ago

      Thanks for asking! I have other 7 data sets and only the sales one has the issue from the very beginning. All data is grey out all the time. I am able to go back to the queries to see the data but not at the data tab. Weird.....

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        Hi Danapa,

         

        I guess there might be something wrong with the sales table, would you mind re-import the sales table to see if the new table greyed out in Data tab?

         

        Best Regards,

        Qiuyun Yu