Dataverse Formula Column (help needed)

I have two dataverse tables.

Asssets:

A unique list of all assets

Asset Bookings:

A list of bookings with a start and end date, where one asset can have many bookings (but not on the same dates).

Is it possible to create a column in the Asset table to show the current status of the asset based on the rule:

If the asset has no active bookings where the start-end date period is today then AVAILABLE but if the start-end date does fall within todays date (i.e there is an active booking) then BOOKED

I created this a column in my Gallery but get a deligation warning and wanted to move the column into dataverse

If(
    IsBlank(LookUp('Asset Bookings', GUID(AssetGUID) = ThisItem.Asset && 'Start Date' <= Today() && 'End Date' >= Today())), 
    "Available", 
    "Booked"
)