Last year to date sales

[sarjensystems1]

Hii..

I have a requirement to calculate last year sales i.e if today date is 19/oct/2019 i need the last year sales from 01/Jan/2018 to 19/Oct/2018

I have used

SAMEPERIODLASTYEAR,

PARALLELPERIOD,dateadd functions but all the functions is not satisfying my requirement....

all the functions are returning the sales from 01/Jan/2018 and 31/Oct/2018

is there any way to do this??

Thanks

[AlB · Accepted solution]

Hi @sarjensystems1 

It would certainly help if you show a sample of your tables. Assuming you are looking for a measure, try this in a card visual:

Measure =
VAR First_ =
    DATE ( YEAR ( TODAY () ) - 1; 1; 1 )
VAR Last_ =
    EDATE ( TODAY (); -12 )
RETURN
    CALCULATE (
        SUM ( Table1[Sales] );
        Table1[Date] >= First_;
        Table1[Date] <= Last_
    )

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers