Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Need help Dax query

Hi All,   I have a logic like below, ⦁ Pull all the invoices for Agency Bill policies that are hitting the GL (based on later of effective or entry date) during the report run period, e.g. ⦁ If a...
Need Help
amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , You need measure like

 


calculate(count(Table[Invoice]), filter(Table, Table[Type] = "Agency Bill" && eomonth([effective date], 0) = eomonth([report run period], 0)))

 

calculate(count(Table[Invoice]), filter(Table, eomonth(Table[invoice Date],2) = eomonth(Table[effective Date],0)))

 

calculate(count(Table[Invoice]), filter(Table, eomonth(Table[invoice Date],-1) = eomonth(Table[effective Date],0)))

 

 

The second and third is made generic using month gap