I have looked at multiple forum postings and unfortunatly they don't quite answer my question. I need to create a really simple measure that filters before a particular date as oppose to usin a visual filter as another calculation need to work off this one.
I have created a calendar as per best practice advice given on the forums.
What I need to do is create a measure that filters SUM([Credit incl VAT]) before 01/06/2017 (dd/mm/yyyy)
I have created a relationship between Invoice Date and dd/mm/yyyy in the calendar table but this was not auto detected.
All I need is an expression (new to DAX) that will give me the filtered measure I am looking for?