sum based on refernce date to today

[#1]

I have a table which details number of hours worked by day/month/year I am looking to calculate total number of hours worked based (fixed date) held in separate table [LTA_Date]

What i am looking to do is sum of hours {'Hours without LTA'} from [LTA_Date] to today

Basically this will give me total number of hours worked from last LTA date

I have the basic hours calulation as below but am struggling to add the extra dimension

= num(sum({<[HType]={'Hours without LTA'}>}[NDA]+[LLWR]+[Sellafield]+[DRS]))

Any suggestions much appciated

[sunny_talwar]

Would it be possible to share a sample with your expected output?

[Anonymous]

try like this?

=sum(<[HType]={'Hours without LTA'},DateField={"$(= '>=' & date(LTA_Date_Value) & '<=' & date(Today))"}>} Sales)

[#4]

=sum(<[HType]={'Hours without LTA'},[LTA_Date]={"$(= '>=' & date[LTA_Date] & '<=' & date(Today))"}>}[NDA]+[LLWR]+[Sellafield]+[DRS])

does not work table image below

[#5]

I have shared below hope fully this will help with resolution