Power BI getting 2 week back same day value

Question

So, I'm attempting to create a measure in Power BI which shall provide to me, the value of sales amount for past two weeks till the current day.

e.g Today = Tuesday 27-Sep-2016 so I need value for Tuesday 13-Sep-2016

Table Format:

 Date       |  SalesAmount
-----------------------------
01-Sep-2016 | 500
02-Sep-2016 | 450
03-Sep-2016 | 650

Answer 1

You can use DATEADD() function to compute the 14 days before each date. Create a measure using the below code.

SalesTwoWeeksAgo =
CALCULATE (
    SUM ( 'Table'[SalesAmount] ),
    FILTER (
        ALL ( 'Table' ),
        COUNTROWS (
            FILTER (
                'Table',
                EARLIER ( 'Table'[Date] ) = DATEADD ( 'Table'[Date], -14, DAY )
            )
        )
    )
)

While the previous DAX expression works, I'd reckon you create a calculated column which is better than the measure-approach when it comes down to performance.