Forum Discussion
updating excel file
i created a dashbord and while i was creating the dashboard i had to create a new table with my existing data. However i have the new data and when i update the data by changing the data source, it updates and refresh perfectly but the calcualted table seems to be blank after i update the data. the screenshot below shows the table view of my calcualted table which is empty and the formula used to create it is okay.
Hi remmy ,
If I understand correctly, the issue is that you couldn’t display the table data. Please try the following methods and check if they can solve your problem:
1.Ensure that the updated data source is correctly connected and accessible.
2.Check the DAX formula used for the calculated table to ensure there are no logical errors.
3.Ensure that there are no filters or slicers applied that could cause the calculated table to appear blank.
4.Review the relationships between the tables in the data model.
Best Regards,
Wisdom Wu
2 Replies
- amitchandak
Super User
remmy , can you share the DAX of calculated column, if created in DAX
Hi remmy ,
If I understand correctly, the issue is that you couldn’t display the table data. Please try the following methods and check if they can solve your problem:
1.Ensure that the updated data source is correctly connected and accessible.
2.Check the DAX formula used for the calculated table to ensure there are no logical errors.
3.Ensure that there are no filters or slicers applied that could cause the calculated table to appear blank.
4.Review the relationships between the tables in the data model.
Best Regards,
Wisdom Wu
