Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
but both give me the same result. in fact, i tried this
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
Solved! Go to Solution.
its solved. it was the fact of not making a relationship between the sales[Date] and the Date column
its solved. it was the fact of not making a relationship between the sales[Date] and the Date column
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |