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

Pavlous

 

There is maybe a record that's still wrong ...

 

CALCULATE ( FIRSTDATE (Archive[Received Date]), Archive[Categories] = "Agreements" ),
        CALCULATE ( LASTDATE('CAS Tasks'[EndTime]), 'CAS Tasks'[Category] = "Agreements" ))

This formula looks correct, but is the result correct ? (First date before Lastdate ?) 

Pavlous's avatar
Pavlous
Advocate II
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.