Forum Discussion
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
its solved. it was the fact of not making a relationship between the sales[Date] and the Date column
1 Reply
- garvicasasHelper I
its solved. it was the fact of not making a relationship between the sales[Date] and the Date column