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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
garvicasas
Helper I
Helper I

sameperiodlastyear

Hi, I'm relatively new to Power Bi and for starting i wanted to do a tutorial. In there they ask you to calculate the total sales and the last year sales, for that they give you the formula:

 

  • Total Sales = SUM(Sales[Revenue])
  • LY Sales = CALCULATE([Total Sales],SAMEPERIODLASTYEAR('Date'[Date]))

 

but both give me the same result. in fact, i tried this

 

 

  • Total Units = SUM(Sales[Units]) 
  • LY Total Units = CALCULATE([Total Units],SAMEPERIODLASTYEAR('Date'[Date])

but this two also give me the same value( between this two, not with the firsts ones)

I'm afraid its a mess with the funtion CALCULATE or SAMEPERIODLASTYEAR, but i couldnt get any clue.

 

BTW, i tried also without result LY Sales = CALCULATE([Total Sales];SAMEPERIODLASTYEAR(DATEADD('Date'[Date];-1;YEAR )))

 

Any help would be apreciated, thanks

 

1 ACCEPTED SOLUTION
garvicasas
Helper I
Helper I

its solved. it was the fact of not making a relationship between the sales[Date] and the Date column

View solution in original post

1 REPLY 1
garvicasas
Helper I
Helper I

its solved. it was the fact of not making a relationship between the sales[Date] and the Date column

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.