Forum Discussion

msommerf's avatar
msommerf
Helper III
5 years ago
Solved

DAX causing system resource issues

Good afternoon,   I have the following DAX formula which I have been using to find the date a vehicle was last inspected:   Last Inspection = calculate(max(bi_vw_InspectionCompleted[Inspection C...
Need Help
Show and Tell
  • danielwelch's avatar
    danielwelch
    5 years ago

    Hi Msommerf,

    While I dont have any advice with regards to M.  You could try the following table based caluclation.  Please note that this assumes that the fields available are within the same table.  If not It may be worth bringing the fields from other tables into this one through their shared ID relationship:

     

    Calculate(Max([InspectionCompleted]),Filter(All([INSPECTIONCOMPLETEDTABLE]),

    ASSETID = Earlier(ASSETID) &&
    InspectionCompleted<Date_Occured ))

    The calculation may run more efficiently if its does not have to look to other tables.


danielwelch's avatar
danielwelch
Resolver II
5 years ago

Hi Msommerf,

While I dont have any advice with regards to M.  You could try the following table based caluclation.  Please note that this assumes that the fields available are within the same table.  If not It may be worth bringing the fields from other tables into this one through their shared ID relationship:

 

Calculate(Max([InspectionCompleted]),Filter(All([INSPECTIONCOMPLETEDTABLE]),

ASSETID = Earlier(ASSETID) &&
InspectionCompleted<Date_Occured ))

The calculation may run more efficiently if its does not have to look to other tables.