Forum Discussion

Mous007's avatar
Mous007
Icon for Helper IV rankHelper IV
6 years ago

Sum AP due before EOM ?

Hi all, So i have the below measure calculated and its working correctly on my report but i want to use it to calculate three new measures that would calculate: only the invoices to be paid before...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Mous007 , Try if these can work

calculate(sum(Table[Invoice Amount]), filter(Table, Table[due_date]<eomonth(Table[due_date],0)))
calculate(sum(Table[Invoice Amount]), filter(Table, Table[due_date]<eomonth(Table[due_date],0)+1))
calculate(sum(Table[Invoice Amount]), filter(Table, Table[due_date]>eomonth(Table[due_date],0)))

Based on Today

calculate(sum(Table[Invoice Amount]), filter(Table, Table[due_date]<eomonth(Today(),0)))
calculate(sum(Table[Invoice Amount]), filter(Table, Table[due_date]<eomonth(Today(),0)+1))
calculate(sum(Table[Invoice Amount]), filter(Table, Table[due_date]>eomonth(Today(),0)))