Forum Discussion

Pavlous's avatar
Pavlous
Advocate II
8 years ago
Solved

Custom Table: Unable to refresh

Hi I have this function for making summary table from 2 other tables which are data sources (Archive is excel export from SharePoint) and CAS TASKS are sharepoint items from list Result = VAR cale...
Need Help
  • Pavlous's avatar
    Pavlous
    8 years ago

    Hello,

    formula was and is absolutely OK. It seeems like the PowerBI is unable to find correct first / last date. Whatever, its working once again.

quentin_vigne's avatar
quentin_vigne
Solution Sage
8 years ago

Hi Pavlous

 

I also had this kind of error with a formula close to yours, I was using a database where one of the operator filled our file with the 'start date' = 18/12/2018 instead of 18/12/2017.

The end date was early 2018 so when making the calculated column I was having an error because of this record.

 

Try to check your files if there is a mistake ? 

 

- Quentin

 

(edited the post)

Pavlous's avatar
Pavlous
Advocate II
8 years ago

Hi quentin_vigne,

So I have checked the files in PowerBI and it seems that our customer archived some record with nonsense 'Received Date'. So the Start date was greater than end date. However, when i filtered it out and double-checked that this condition is fullfilled, it still shows the same error message.

 

However thank you for your tip :)