Solved: Last year to date sales

sarjensystems1 · ‎10-19-2019

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 · ‎10-19-2019

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

View solution in original post

AlB · ‎10-19-2019

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