Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good afternoon,
I have the following DAX formula which I have been using to find the date a vehicle was last inspected:
Solved! Go to Solution.
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.
Hi @msommerf,
AFAIK, current power query functions are also not suitable for your requirement. They are good at data shaping/clean and transform data structure instead of calculation through whole table records with particular filters.
BTW, what type of data source are you worked on? If you are using SQL server or other data source that supported advanced queries, you can try to use query to add some additional fields to reduce the looping calculations.
Regards,
Xiaoxin Sheng
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.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |