Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
sarjensystems1
Helper III
Helper III

Last year to date sales

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
1 ACCEPTED SOLUTION
AlB
Super User
Super User

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  Datanaut

View solution in original post

1 REPLY 1
AlB
Super User
Super User

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  Datanaut

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.