cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
knche1234 Frequent Visitor
Frequent Visitor

Total Sales Last Year , Need Help!!

Hi!

 

Need help with the following scenario: 

 

I need to calculate the count of Last Year YTD Sales: 

 

LY YTD Sales = TOTALYTD([YTD Sales],SAMEPERIODLASTYEAR('BASE BBI AS400'[Fecha Activación].[Date])) 

 

Apparently it is showing the amount of all sales in 2016 and not the value YTD I am looking for, it shows all 2016 sales. 

 

I used the following formula to calculate YTD sales: 

 

YTD Sales = TOTALYTD(COUNTAX('BASE BBI AS400','BASE BBI AS400'[Anexo]),'BASE BBI AS400'[Fecha Activación].[Date])

 

This formula shows the exact amount for sales starting 01/Jan/2017. 

 

How can I fix the formula to show the total last year from same period on this year? 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Microsoft Phil_Seamark
Microsoft

Re: Total Sales Last Year , Need Help!!

Have a bit of a read through this article.

 

https://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/

 

and see if that helps any,


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

1 REPLY 1
Microsoft Phil_Seamark
Microsoft

Re: Total Sales Last Year , Need Help!!

Have a bit of a read through this article.

 

https://www.kasperonbi.com/get-the-ytd-of-same-period-last-year-using-dax/

 

and see if that helps any,


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors