I have an excel table the tracks daily hours and calculates pay. The legacy system I get the post records from. I want to summarize the current period daily pay from excel using a date filter against my 2019 payroll cutoff table.
I am not sure how to develop the calculate statement specifically the filter. Without slicer based upon today’s date
Calc below is not correct trying to work through this
Current Payperiod $ = CALCULATE( SUM(Main[Daily Pay]), FILTER(ALL(Cal), Cal[Date] > LASTDATE('2019 Pay Period'[StartDate].[Date])) )